Re: Query tuning

From: Yvan GALAS <yvan.galas_at_fr.adp.com>
Date: Tue, 08 Apr 2003 12:08:01 +0200
Message-ID: <b6u75h$iup$1@pegase.atos-infogerance.fr>

Hi,

of course yes... it's the basis of tuning... !!!

1 - Number of rows in each tables (For the correct ordering of the FROM clause... t1 pow t2 is not the same as t2 pow t1) 2 - Distinctive data in each columns
3 - Put a index on these distinctive data etc ......

Guido Konsolke wrote:
> Hi Rajesh,
>
> do you really think all that matters
> in this case is to know the number of
> records in the involved tables?
>
> Come on. Feed us.
>
> Greetings,
> Guido
>
>
Received on Tue Apr 08 2003 - 05:08:01 CDT