Yup.

That’s cause you’re not actually the database tables. You’re only hitting the index. ;-)

 

Kinda fun, aint it?

 


From: Nurullah Akkaya [mailto:nurullah_akkaya@yahoo.com]
Sent: Tuesday, February 06, 2007 4:52 PM
To: Derby Discussion
Subject: Re: keeping the table ordered

 

for who ever searches these archives creating a composite index that includes all the columns i query solved the problem. i can read 2.7 million records in 11 seconds another query that selects around 800k records dropped to about 4 secs.