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]

Reply via email to