Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!sn-xit-03!sn-xit-04!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: Improve this querry!? Date: Tue, 11 Nov 2003 12:33:54 -0800 Organization: ATS Message-ID: <1068582855.978244@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <9c9c6d17.0311071045.19c8d337@posting.google.com> <1068245369.453336@yasure> <9c9c6d17.0311100840.46a497a1@posting.google.com> <1068483998.189348@yasure> <9c9c6d17.0311110906.18ddca9e@posting.google.com> In-Reply-To: <9c9c6d17.0311110906.18ddca9e@posting.google.com> Content-Type: multipart/alternative; boundary="------------000202080708050807000405" Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 106 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:133039 --------------000202080708050807000405 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Mark Schubert wrote: >>Running Explain Plan is essential. The fact that indexes exist does not >>mean that indexes are used. >>Go to http://tahiti.oracle.com and print out the documentation for >>running Explain Plan. Basically >>you will need to run the utlxplan.sql script in $ORACLE_HOME/rdbms/admin >>to build the plan >>table and then use the explain plan syntax to create the plan. Printing >>it out can be done with any >>number of scripts available all over the web. Contact me off-line if you >>can't find a copy. >> >>You may not understand everything about the output ... but you will be >>able to tell immediately >>whether the indexes are being used. >> >> > >Again, I'd be happy to run the Explain Plan if it will somehow lead to >a solution. I can't help thinking it will just bring further questions >and more actions. > Re-read the first sentence above. If others have helped you I am glad. Because obviously I can't. BTW: If you had sent your email from a non-US address I'd have known you are not a native English speaker. If you had said anything to that affect I'd have known. You expect people to not only do your work for you, but to guess your native language. Guess I'm just too dense to do either so I'm kill-filing this thread. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) --------------000202080708050807000405 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Mark Schubert wrote:

Running Explain Plan is essential. The fact that indexes exist does not 
mean that indexes are used.
Go to http://tahiti.oracle.com and print out the documentation for 
running Explain Plan. Basically
you will need to run the utlxplan.sql script in $ORACLE_HOME/rdbms/admin 
to build the plan
table and then use the explain plan syntax to create the plan. Printing 
it out can be done with any
number of scripts available all over the web. Contact me off-line if you 
can't find a copy.

You may not understand everything about the output ... but you will be 
able to tell immediately
whether the indexes are being used.


Again, I'd be happy to run the Explain Plan if it will somehow lead to
a solution. I can't help thinking it will just bring further questions
and more actions.

Re-read the first sentence above.

If others have helped you I am glad. Because obviously I can't.

BTW: If you had sent your email from a non-US address I'd have known you are not a native
English speaker. If you had said anything to that affect I'd have known. You expect people to not
only do your work for you, but to guess your native language. Guess I'm just too dense to do either
so I'm kill-filing this thread.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

--------------000202080708050807000405--