-
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 .
Vinit
-
Local Partitioned Index will give better performance.
If index is available, then full table scan will be done.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|