-
I have a partitioned table that has a global primary key index and it is partitioned by date and has a local index on each partition using that date. I have wirtten a query in my program that selects a record giving it the date value and then the primary key values. My thought was it would find the correct partition using the local index then use the primary key info to find the record inside of that partition. Is that correct? Or does it find the partition and then scan the whole partition to find the record because the primary key is global? It seems that when I just give it the primary key info without the date it runs faster.
-
What does the query plan say?
Jeff Hunter
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
|