How to find out about index - Mailing list pgsql-general

Hi all,

I am new to postgre.I want to create index on some of the column.

I just wanted to know that how to find out on which column we need to
create index because using explain command I am not getting the clear
picture as we get in oracle if we use the same explain plan command.

I am unable to decide where should I create the index based on which
criteria.

Any help will be highly appreciated.


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