Re: Why are optimizer hints required?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 9 Mar 2005 19:29:21 -0000
Message-ID: <422f4e8e$0$10946$cc9e4d1f@news-text.dial.pipex.com>

comments embedded
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:d0mc6t$q0v$1_at_hercules.btinternet.com...
> So it's worth knowing that in 10g, you can specify an index
> by 'describing' it. e.g.
> /*+ index(tab1 tab1(col1, col2)) */
> Meaning 'use an index starting with (col1, col2).

This was what I was hinting at (sorry) with my earlier comment. I'm interested if it means 'starting with col1,col2' or 'including both col1 and col2 with one of them as a leading column' or 'any usable index that includes col1 and|or col2' - I'm sure this is all documented somewhere.

In addition I'd be interested in any bugs/usage oddities (bitmap indexes) etc that people have come across with this syntax.

I guess what I'm saying is that the feature sounds very attractive, but I wonder what its quirks are.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Wed Mar 09 2005 - 13:29:21 CST