Re: distinct too slow

From: Spencer <spencerp_at_swbell.net>
Date: Sun, 18 Feb 2001 17:59:49 -0600
Message-ID: <slZj6.223$o81.6336@nnrp1.sbc.net>

"jkl" <jkl_at_novabase.pt> wrote in message news:982314963.524051_at_tubarao.ip.pt...
> How can I speedup a query that uses distinct?
> Tanks.

basically, you need to identify the bottleneck, and tune around it. i would suggest doing an "explain" on the execution plan for the query, and collect a "trace" file. the basic tuning approach is to minimize the number of rows (and database blocks) accessed, retrieved, sorted, etc. by the query. re-writing the query, or using hints, or modifying the schema (e.g. adding an index) are all options to consider. Received on Sun Feb 18 2001 - 17:59:49 CST