Re: Help! This group by stmt takes AGES

On 26 Apr 2002 15:14:27 -0700, frankzaum_at_yahoo.de (Frank Zaum) wrote:
>
>perhaps the statement can be changed to something not using the group by clause.
>but how?. in the end, i just want to select the values per day and tablespace,
>not the day itself (column datum contains trunc(sysdate))
>but i dont know how to figure the correct select statement for that.

I have a "how many per day" query that starts like:

select

   distinct
   trunc(time_stamp),
   count(*) over(partition by trunc(time_stamp)) per_day    from ...

Since you already have the truncated date stored, so much the better!

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/