Stack Exchange

David Aldridge

Haddenham, United Kingdom

oraclesponge.wordpress.com

Business Intelligence Architect
PostgreSQL developer
Ruby on Rails Developer
Oracle Data Warehouser
Survivor of Informatica and Business Objects

Oracle ACE
top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
129
Fetch the row which has the Max value for a column
stackoverflow.com

45
How do you interpret a query's explain plan?
stackoverflow.com

30
When and why are database joins expensive?
stackoverflow.com

28
What's the difference between TRUNCATE and DELETE in SQL
stackoverflow.com

23
MySQL vs. SQL Server vs. Oracle
stackoverflow.com

22
What is the difference between a hash join and a merge join (Oracle RDMBS )?
stackoverflow.com

20
How to choose and optimize oracle indexes?
stackoverflow.com

14
Any performance impact in Oracle for using LIKE 'string' vs = 'string'?
stackoverflow.com

13
SQL to find the number of distinct values in a column
stackoverflow.com

12
Hidden features in Oracle
stackoverflow.com

12
Best beginner resources for understanding the EAV database model?
stackoverflow.com

12
Can We use threading in PL/SQL?
stackoverflow.com

12
A “simple” 3rd grade problem…or is it?
math.stackexchange.com

10
SQL/Oracle: when indexes on multiple columns can be used
stackoverflow.com

9
Can Multiple Indexes Work Together?
stackoverflow.com

9
Hidden features in Oracle
stackoverflow.com

9
ORA-01830: date format picture ends before converting entire input string
stackoverflow.com

9
Why are constraints applied in the database rather than the code?
dba.stackexchange.com

8
Hidden features in Oracle
stackoverflow.com

8
Hidden features in Oracle
stackoverflow.com

8
problem with mutating tables
stackoverflow.com

8
Delete all but some rows - Oracle
stackoverflow.com

8
index with multiple columns - ok when doing query on only one column?
stackoverflow.com

8
How to move sorting to the database level
stackoverflow.com

8
From Oracle to MS-Access to Mysql
stackoverflow.com

7
Inner join vs Where
stackoverflow.com

7
How many database indexes is too many?
stackoverflow.com

7
What happens to an Oracle sequence after disaster recovery?
stackoverflow.com

7
Hidden features in Oracle
stackoverflow.com

7
What does/should NULL mean along with FK relationships - Database
stackoverflow.com

1 2 3