I have a simple SELECT statement that I run against a partitioned table in EEE 7.2 as follows:
select * from mytab;
This statements starts pumping out data as soon as I press Enter. However, if I change the statement to:
select * from mytab fetch first 2 rows only;
it takes over 2 minutes to come back and show me the 2 rows. Explain is showing that it is doing an INDEX SCAN, SORT, RIDSCN, BTQ before returing the 2 rows. Since I don't have an 'ORDER BY' clause, I am curious as to why it is doing all this sorting. The STATS is up to date for the table.
Thanks
Aidin
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
