Bernie, What do you get if you try these:
SELECT DISTINCT CreditDate FROM Credits SELECT CreditDate, COUNT (*) FROM Credits GROUP BY CreditDate SELECT CreditDate FROM Credits GROUP BY CreditDate Do you get the doubled dates any of those ways? Also, just in case all those extra eyes might see something, please show the results of: LIST COLUMN CreditDate LIST COLUMN CreditAmount LIST TABLE Credits SHOW DATE SHOW ZERO SHOW NULL Bill On Thu, Apr 24, 2008 at 4:56 PM, Bernard Lis <[EMAIL PROTECTED]> wrote: > 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 >> >> >> >> > >
