RE: How to track DB usage of user

[Thomsen, Dirk]

Hello,

>-----Original Message-----
>From: Robert Klemme [mailto:[EMAIL PROTECTED] 
>Sent: Dienstag, 20. September 2005 18:31
>To: [EMAIL PROTECTED]
>
>> or use select count(*)*avg(length(YourVarcharField)) from t1
>
>select sum(length(YourVarcharField)) from t1 where userid = 1234 is
much simpler


 please note that the two sql-statements 

        select count(*) * avg(<expression>) from t1

                and

        select sum(<expression>) from t1

are NOT equivalent if <expression> maybe NULL. The equivalent
sql-statements would be  

        select count(<expression>) * avg(<expression>) from t1

                and

        select sum(<expression>) from t1



Kind regards, 

        Dirk Thomsen
        SAP Labs Berlin