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:[EMAIL PROTECTED] 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.