Queries on partitioned table are sometimes slow [message #375051] |
Fri, 20 July 2001 13:12 |
Clayton
Messages: 2 Registered: July 2001
|
Junior Member |
|
|
Hi,
I have a partitioned table where the speed of queries is sometimes strangely slow. Each of these queries executes right away:
select * from labdata_x where tagname = 'TEST6';
select entrydate from labdata_x where tagname = 'TEST6';
But each of these queries takes about 9 seconds:
select tagname from labdata_x where tagname = 'TEST6';
select status from labdata_x where tagname = 'TEST6';
The labdata_x table has about 2 million rows and I partitioned it as an experiment. I have local, nonprefixed indexes on tagname and status.
Basically what's happening is that retrieval is slow when I select an indexed column, fast otherwise. This doesn't make sense to me, regardless of partition and index setup, because the where-clause is exactly the same in all queries. Shouldn't it take exactly the same amount of time to find a row, regardless of which column I request?
Any ideas or suggestions would be appreciated!
Clayton
|
|
|