Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on Indexes!
> adrianh_at_globalnet.co.uk (Adrian Harrison) wrote:
You can search all 3 ways by creating 2 indexes as follows
index1 on (col1,co2)
index2 on (col2)
any query on col1 should use index1 (optimizer aside)
any query on col2 will use index2
any query on both columns will use index1
Conan Received on Fri Jan 15 1999 - 14:22:18 CST