That's a great SQL tuning presentation, but I don't follow what he says in slide #91:
------------------------------------------- "No WHERE clause with an ORDER BY" Often a screen will return rows with a predefined order, e.g., ORDER BY NAME. The user is expected to enter a NAME or part of a name, NAME=SMI. If the user presses Enter for the query without entering a name, all table rows must be sorted. So always have a WHERE NAME > CHR(1). -------------------------------------------- What does the extra WHERE clause do for you? > Yesterday at the SDOUG meeting Mark Gurry gave a 2 hour > presentation on tuning. His slides can be found at > > http://www.sdoug.org/ > > Slide #62 held the answer to Rajendra Jamadagni index problem. > > He's the author of a couple of books on Oracle & SQL tuning. > > HTH & HAND! > > -- > Charlie Mengler Maintenance Warehouse > [EMAIL PROTECTED] 10641 Scripps Summit Ct. > 858-831-2229 San Diego, CA 92131 > Extraordinary DBA - Design on the Fly & Just In Time Programming > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Charlie Mengler > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).