Re: How to find out about index

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to find out about index
Date: 2002-10-08 06:02:34
Message-ID: 3DA2C252.197.13E05102@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Steffen 2002-10-08 06:31:53 deadlock detected
Previous Message Joe Conway 2002-10-08 05:58:10 Re: PLTCL return_null crash...