"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:d0iame$5r7$1_at_sparta.btinternet.com...
> Oracle 10g has a nice little feature that once
> you got 'nice' stats on an object, you can lock
> them so that they don't get overwritten.
I believe that it also has a similarly nice feature that allows you to hint
for an index based not on the index name, but the table and column names. I
haven't however used this feature so cannot comment on its real-life
usefulness.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Tue Mar 08 2005 - 00:39:08 CST
