Re: How can I tune this query?????

In Article<4k1rrv$js0_at_ni1.ni.net>, <mmc_at_hermes> write:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.internetmci.com!csn!news-1.csn.net!ub!newsstand.cit.cornell.edu!news.tc.cornell.edu!newsserver.sdsc.edu!news.cerf.net!ni1.ni.net!mmc
> From: mmc_at_hermes (Maxxwell M. Cassidy)
> Newsgroups: comp.databases.oracle
> Subject: Re: How can I tune this query?????
> Date: 5 Apr 1996 01:09:19 GMT
> Organization: I need to put my ORGANIZATION here.
> Lines: 27
> Message-ID: <4k1rrv$js0_at_ni1.ni.net>
> References: <4jbpgi$ets_001_at_nuts.nwu.edu> <4joprh$lud_at_phoenix.michsb.trw.com>
> NNTP-Posting-Host: hermes.yucca.com
>
>
> Dear Andrea:
>
> While all of the other suggestions that others have
> offered may help, what you need is a method to tune
> these queries. This tuning cannot be done without
> more information. The first step is to find out how
> the query is being executed.
>
> What is the "plan" for the query? In Sybase, "set
> showplan on" will give you this. There is a similar
> setting in Oracle, although I can't remember what it
> is at the moment. If you have any table scans going
> on, make sure that the query requires more than 1/2
> the rows of the table to do its work. Make sure you
> rewrite the query so this is unnecessary, if you can.
> But see what the database is spending this time on,
> and then minimize the biggest piece of it. There is
> no "right" answer to how to tune a database. Try
> things. Use what works.
>
> Maxxwell M. Cassidy.
> --
> o---------------------------------------------------------------o
> | Maxxwell M. Cassidy, |
> | President, |
> | Yucca Mist, Inc. |

this is just to add that the missing utility is "explain plan for <query>" I don't know what the original problem was so I can't comment on that Received on Sun Apr 07 1996 - 00:00:00 CEST