That’s cause you’re not
actually the database tables. You’re only hitting the index. ;-)
Kinda fun, aint it?
From: Nurullah Akkaya
Sent: Tuesday, February 06, 2007
To: Derby Discussion
Subject: Re: keeping the table
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.