Right on John, but for the record CreditDate is not indexed.
----- Original Message -----
From: "John Engwer" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, April 24, 2008 10:23 AM
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
Larry, he created a temp table and ran the select from the temp table.
That
should have eliminated the index possibility.
John
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence
Lustig
Sent: Thursday, April 24, 2008 9:56 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
Bernie:
I'll bet dollars to donuts this is an indexing issue.
Is CreditDate indexed? If so, try dropping the index and repeating the
command (which will run more slowly). In fact, try projecting a
completely
unindexed copy of the table and operating on that.
Also, look for CreditDate used in a multi-column index.
--
Larry
