Indexed subfiles are S-L-O-W

Maclary, David dmaclary@wellington.com
Thu, 4 Oct 2001 15:16:45 -0400


I'm wondering if anyone else has had the following experience...

In Quiz, I can...
> ACCESS subfile
> SET REPORT LIMIT 999999
> GO
and it's fast.

If I create an indexed version of the subfile, and do the same thing...
> ACCESS subfile
> SET REPORT LIMIT 999999
> GO
it talks a very long time.

Anyone know why? And how to speed this up?

Regards,
David Maclary
DMaclary@Wellington.Com