Re: SQL Tuning Question (8.1.7)

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 05 May 2004 21:47:53 +1000
Message-ID: <4098d462$0$12740$afc38c87@news.optusnet.com.au>

Howard J. Rogers wrote:

> Jeremy wrote:
>

>> Hi Guys, what's the best resource (on the web) to look at for info on 
>> tuning SQL and defining suitable indexes for a query (at this point I 
>> expect someone to say you don't create indexes for a query, they 
>> should be a part of the overall application design)? I am 

>
>
> It doesn't answer your specific questions, and is only one pointer, and
> not particularly good news at that, but there's a new article on
> identifying useful versus useless indexes on www.dizwell.com (FAQ basic
> admin).
>
> With regard to the optimiser changing plans when you add in a new
> column, you don't say what version,

You do of course, in the thread topic. My apologies. My point was that the optimiser has got steadily more sensible over time and versions, and by 9i is pretty damn good, generally. It wasn't too bad in 8.1.7 either, so don't panic.

Regards
HJR Received on Wed May 05 2004 - 06:47:53 CDT