Thanks Matthew, does that mean i can just have index1, index3, index4?
On Wed, Aug 20, 2008 at 8:54 PM, Matthew Wakeling <[EMAIL PROTECTED]>wrote: > On Wed, 20 Aug 2008, Kranti K K Parisa™ wrote: > >> creating multiple indexes on same column will effect performance? >> for example: >> >> index1 : column1, column2, column3 >> index2: column1 >> index3: column2, >> index4: column3 >> index5: column1,column2 >> > > The sole purpose of indexes is to affect performance. > > However, if you have index1, there is no point in having index2 or index5. > > Matthew > > -- > Isn't "Microsoft Works" something of a contradiction? > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Best Regards Kranti Kiran Kumar Parisa M: +91 - 9391 - 438 - 738 +91 - 9849 - 625 - 625
