Pack your indexes on the source table Dennis McGrath
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Wednesday, April 23, 2008 11:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Group by -- need another set of eyes Hi Mike, It's a table, not a view -- but thanks for thinking about it anyway. Bernie Lis ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, April 23, 2008 12:09 PM Subject: [RBASE-L] - RE: Group by -- need another set of eyes > Bernard: > > Is this based on a table or a view? If it's a view does it by any chance > have a UNION clause in it? I have experienced something similar when > using > a view with a UNION to determine correct data types. > > Mike Ramsour > AK Steel Coshocton Works > Quality Department > > Phone/VMS: 740-829-4340 > > -----Original Message----- > From: Bernard Lis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 23, 2008 12:04 PM > To: [email protected] > Subject: [RBASE-L] - RE: Group by -- need another set of eyes > > Hi Sami, > You mean like this: > > sel CreditDate,sum(Creditamount)=s from Credits where Creditdate between > 3/1/2008 and 3/31/2008 group by CreditDate > CreditDate sum (Creditamou > ---------- --------------- > 03/23/2008 2,952.16 > 03/30/2008 2,819.19 > 03/23/2008 2,952.16 > 03/30/2008 2,819.19 > ---------- --------------- > 11,542.70 > > > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
