I think y'all need a hobby- and one that doesn't include oracle! -Kellyn ------Original Message------ From: Job Miller Sender: oracle-l-bounce@xxxxxxxxxxxxx To: martin.a.berger@xxxxxxxxx To: ORACLE-L To: jaromir@xxxxxxxxxxxx ReplyTo: jobmiller@xxxxxxxxx Subject: Re: fastest SQL? Sent: Mar 12, 2010 7:44 AM This whole threads sounds like a trick interview question for a DBA. Q: You are presented a really slow SQL statement, what do you do, or how do you tune the SQL statement to make it really fast? You look at the statement/business logic and decide that you don't need to run that statement at all. Jaromir gets my vote. -- //www.freelists.org/webpage/oracle-l Sent via BlackBerry from T-Mobile -- //www.freelists.org/webpage/oracle-l