Re: Use Partition speed Query?

All your queries are using the primary key index table to search.

The partitioning of your table doesn't help much to the queries on the same data set:

    The time to search in one partition is the same as the time to search the table which has all the rows for that partition.

    That happens when you compared the speed of Q2 and Q4, Q1 and Q3.     The result set of (Q1,Q3) is more than (Q2,Q4), therefore the search time is longer.

You can construct an equipartitioning index on the table:

create index indexname
on SubSaleCard (Salecard_No,Uni_No)
local
(Partition Part1997,
 Partition Part1998',
 Partition Part1999,
 Partition PartOther);

of cause you can go one step further by specifying the indexes/partitions residing on different tablespace/disk controller

Oracle will use this partitioned index to search your queries. The performance will be a improved.

Please email me with your results.

HTH John Chiu Received on Sat Dec 04 1999 - 14:09:27 CST