Re: Using more than one Index
Posted by:
James Day
Date: December 18, 2004 11:30AM
It's one per table alias, so if you used a self join you could use two or more indexes, one for each join/alias. Might involve rewriting quite a lot of queries, though.
Subject
Views
Written By
Posted
4552
December 18, 2004 09:04AM
Re: Using more than one Index
2404
December 18, 2004 11:30AM
2418
December 18, 2004 12:36PM
2273
December 20, 2004 06:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.