Received: from ip.eth.net (mail2.ip.eth.net [202.9.128.19]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBB48Gm20969 for ; Mon, 10 Dec 2001 23:08:17 -0500 (EST) (envelope-from sharmad@goatelecom.com) Received: (apparently) from punweb01 ([10.1.1.14]) by ip.eth.net with Microsoft SMTPSVC(5.5.1877.467.46); Tue, 11 Dec 2001 09:38:14 +0530 From: sharmad@goatelecom.com Reply-to: sharmad@goatelecom.com To: pgsql-sql@postgresql.org Date: Tue, 11 Dec 2001 09:38:54 +0550 Subject: Indices X-Mailer: DMailWeb Web to Mail Gateway 2.7q, http://netwinsite.com/top_mail.htm Message-id: <3c1586d6.6d0.0@punweb01> X-User-Info: 61.1.72.159 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/114 X-Sequence-Number: 5937 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