Re: [SQL] making queries more effecient

2002-11-01 Thread Josh Berkus
Chad, > Im not sure I can get my head around the difference between doing your > subselect > > INSERT INTO "VisitorPointer839" ("VisitorID") > SELECT "VisitorID" FROM ( > SELECT DISTINCT ON ("VisitorID") "VisitorID","Type" > FROM "ProgramEvent" WHERE "ProgramID" = 10 > ORDER BY "VisitorID","

Re: [SQL] making queries more effecient

2002-11-01 Thread Josh Berkus
Peter, For the rest of our sakes, in the future, please format your SQL before posting it to request help. > CREATE TEMP TABLE temp20561149207391 AS SELECT DISTINCT ON ("VisitorID") > "VisitorID","Type" FROM "ProgramEvent" WHERE "ProgramID" = 10 ORDER BY > "VisitorID","Created" DESC;INSERT INTO

Re: [SQL] making queries more effecient

2002-11-01 Thread Chad Thompson
found that group by works faster than distinct in some cases. You may have to test it for your senario. Thanks Chad - Original Message - From: "Peter T. Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 01, 2002 3:24 PM Subject: [SQL] making

[SQL] making queries more effecient

2002-11-01 Thread Peter T. Brown
Hi. I have this query that I have been trying to reduce to a single statement, but haven't figured out how. Am I missing something? CREATE TEMP TABLE temp20561149207391 AS SELECT DISTINCT ON ("VisitorID") "VisitorID","Type" FROM "ProgramEvent" WHERE "ProgramID" = 10 ORDER BY "VisitorID","Created"