partition table query speed much much slower than normal table
370904Dec 16 2003 — edited Dec 17 2003Hi,
I create a partition table and spread the datafile in 5 different tablepsace in different hardisk. I create another normal table with same structure also. But something really puzzle me when I querying these two tables, the partition table querying speed is MUCH MUCH slower than the normal table. I thought the partition table should be query in more efficient way since it can retrieve record in 5 different hardisks, but the outcome really puzzle me. Can someone tell me what will cause this happen??
Thks