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
