DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Gloabl vs. Local Partition

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width