List:General Discussion« Previous MessageNext Message »
From:walter harms Date:July 24 2008 12:49pm
Subject:how to optimize: max(timetstamp) where a.foo=b.foo ?
View as plain text  
hi list,
i have tables that look like this( <10.000 entries) :

id,
timestamp,
value


to get the latest value for each id i have queries like:

select * from tab A where timestamp = (select max(timestamp) from tab B where B.id=A.id)
group by id ;

on a fast system it takes round 4 sec to complet, but since this is done requlary it slows
down to much.
the same query takes on a informix system an a slower computer next to nothing.

any ideas ?

re,
 walter


Thread
how to optimize: max(timetstamp) where a.foo=b.foo ?walter harms24 Jul
  • Re: how to optimize: max(timetstamp) where a.foo=b.foo ?Mr. Shawn H. Corey24 Jul
  • Re: how to optimize: max(timetstamp) where a.foo=b.foo ?Peter Brawley24 Jul
    • Re: how to optimize: max(timetstamp) where a.foo=b.foo ?walter harms24 Jul