Re: Query Performance.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 23 Jan 2001 14:48:19 GMT
Message-ID: <3a6d98fa.1199336500@news.alt.net>

On Tue, 23 Jan 2001 06:13:46 GMT, Ed Prochak <prochak_at_my-deja.com> wrote:

>Without the text of the queries (how you joined the view and other
>tables), and information about the tables (keys, indices, etc.) it is
>really difficult to say. Adding a new table may provide the optimizer a
>different and more efficient search path thru the data. Or the
>condition used to join the table reduces the result set. Or even you are
>on a slow machine and the timings alone don't mean anything.
>

I didn't want to give out the text of the queries. I read these newsgroups and some people give actual names of tables, while others make up names. This query was a bit too hard to make up names names and follow it properly.

>Since Sybrand brought his name up in another thread, I'll mention:
>
>Guy Harrison has a book on Oracle Performance Tuning.
>
>It's very helpful and informative. I don't just recommend it, I use it.
>

I'd love to read mopre, but I have too much to read already!

Brian Received on Tue Jan 23 2001 - 08:48:19 CST