I have two tables taht are exactly the same (indexes fields etc) but in different schemas. The one is partitioned, and the other one is not.. Both tables have about 1000000 records.
The partition table has 5 partitions with the follwing number of data per partition:
P1 : 0
P2 : 271697
P3 : 1200172
P4 : 10113986
P5 : 451153
I also have a global index on the partitioned table.
Now I am running a query that selects some fields from this table based on the partitioning key which is also the indexing key for tha global index (that is thhe where field is the partition key). With this query I try to retrieve data that exist in the second partition (with 271697 records)
The strabnge is taht for this query I get the same execution time for both tables!
Thought I suppose that I should need less time for the execution in the partitioned table!
The only case I get less time, is when I specified the partition in the FROM of the query for the partition table.
Can anybody help me to understand why this is working like this? And how I can tune this?
Thanks for your help
August 25, 2008 12:30 PM
August 26, 2008 2:23 PM