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,IPADDRESS
I 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]