Indices

From: sharmad(at)goatelecom(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Indices
Date: 2001-12-11 03:48:54
Message-ID: 3c1586d6.6d0.0@punweb01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
Having to manny indices to a table,does it effect the performance of a table.Like
a table having following structure

Name :
First name,
Second Name,
Third name,
Age,
Address.

Is it good here to have multiple indices like on only first name, only second
name,only third name and all other combination of first ,second and third name
or the performance increases when we have only 1 indice of all first ,second
and third name
Thanks
-Sharmad

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-12-11 18:46:32 Re: Indices
Previous Message Stephan Szabo 2001-12-10 21:33:54 Re: [SQL] Can anybody help me with SQL?