Received: from ns.itd.sterling.com (ns.itd.sterling.com [192.124.9.5]) by hub.org (8.8.8/8.7.5) with SMTP id JAA09125 for ; Tue, 4 Aug 1998 09:40:55 -0400 (EDT) Received: ns.itd.sterling.com id AA00771; Tue, 4 Aug 1998 08:34:52 -0500 Received: from willie (willie.itd.sterling.com [199.4.254.237]) by Cyclone.itd.sterling.com (8.6.9/8.6.9) with SMTP id JAA05233 for ; Tue, 4 Aug 1998 09:40:04 -0500 Message-Id: <005d01bdbfae$0eaac810$edfe04c7@itd.sterling.com> Reply-To: "Chris Williams" From: "Chris Williams" To: Subject: Which index is better for join operations Date: Tue, 4 Aug 1998 09:44:48 -0400 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3115.0 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3110.3 I have a SQL statement that is SLOW and I am wondering if using a hash index instead of a btree on the fields that are used for the join operations would be faster? Anyone have any input on this. The query is between 3 tables. If you need any more details, please let me know. Thanks --------- Chris Williams Sterling Software Rome, New York Phone: (315) 336-0500 Email: chris_d_williams@sterling.com