Partitioned indexes

[vinit]

Hi guys,

I have a datawarehousing App. I have a table with 80 million rows.It has 8 partitions(1 for each year).

Which will give me a better performance

1. Partitioned Index or non-partitioned index.

2. If Partitioned, local or global .

3. If non-partitioned, then how does the search happen - using index or a full table scan. (sorry cannot analyze the data coz this is still in dev. stage)

4. We are using the partition key in the where clause.

Oracle version is 8.1.7.2 and OS is Digital Unix .

[tamilselvan]

Local Partitioned Index will give better performance.

If index is available, then full table scan will be done.