On Wed, Mar 31, 2004 at 05:41:03PM -0500, Randall Skelton wrote:
> Can someone please explain how I can make this sub-query faster? In
> the case below, 'test' is a temporary table but I have tried with test
> being a full, indexed, and 'vacuum analysed' table and it still takes
> more than 130 seconds. Note that 'test' has very few rows but
> 'cal_quat_1' has many rows.
Have you tried just using a join? Like:
explain analyze select value from cal_quat_1, test where timestamp = t
order by t;
Also, an index on cal_quat_1.timestamp might be good too...
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> This space intentionally left blank