Re: How to find out about index

On 8 Oct 2002 at 11:21, Savita wrote:

> 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.

Create indexes on columns that are used in where condition of select query.

HTH

Bye
 Shridhar

--
Lie, n.:    A very poor substitute for the truth, but the only one    discovered to
date.