Re: performance issue

Hi,

I was looking for something like this.

InMssql when I use a query like selece a,b from some table where
a.x=b.y,then if a is having say 30000 records and b is having 4 records then
it will compare all the 30000 records with the 4 records one by one,but if I
make it where b.y=a.x then it will be faster.

I know with index I could increase the performance by 50 %,but what other
possibilities are there to improve the performance

Stephan Szabo wrote:

> On Mon, 28 Oct 2002, Savita wrote:
>
> > Using explain I am not able to get the detailed information.
>
> What information are you looking to get?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------