Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

RE: Local vs. Global Indexes

Kevin Toepke

2004-02-26

Replies:

Message
There are a couple reasons that you may want/need to use a global index.
 
If you have a unique index that does not have the partition key as the leading column, I believe, you need to use a global index.
 
If you are not using the partition key in your where clause, using a global index will speed the performance of the query.
 
But I agree, if you can, use local indexes.
 
Kevin
-----Original Message-----
From: Ryan [mailto:ryan.gaffuri@cox.net]
Sent: Wednesday, February 25, 2004 9:34 PM
To: oracle-l@freelists.org
Subject: Local vs. Global Indexes

I pretty much only use local indexes. Do any of you use global indexes on partitioned tables and why?
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.