2006/4/28, Robert Klemme <[EMAIL PROTECTED]>:
> INSERT INTO "MAIN"."T_VISITS" > SELECT > COUNT("ID") AS REQUESTCOUNT, > "SESSIONID" AS SESSIONID, > MIN("PSESSIONID") AS PSESSIONID, > MIN("CREATIONDATE") AS CREATIONDATE, > MIN("IPADDRESS") AS IPADDRESS > FROM "MAIN"."REQUEST" > > with the Index to PSESSIONID, CREATIONDATE,IPADDRESSI don't see any GROUP BY. That will "aggregate" to a single record. Is this really the statement you are using? Is this really what you want?
I have to correct myself: I confused single and double quotes for a moment. So this statement really misses a GROUP BY (probably GROUP BY "SESSIONID"). Regards robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
