Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4UMwRE16020 for ; Wed, 30 May 2001 18:58:27 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.10.1/8.10.1) id f4UMviC16759; Wed, 30 May 2001 18:57:44 -0400 (EDT) From: Bruce Momjian Message-Id: <200105302257.f4UMviC16759@candle.pha.pa.us> Subject: Re: Using indexes In-Reply-To: <3B157646.EABF2998@computalog.com> "from Linh Luong at May 30, 2001 04:37:58 pm" To: Linh Luong Date: Wed, 30 May 2001 18:57:44 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200105/349 X-Sequence-Number: 3190 Man I am tired of this question. I have updated the FAQ:

Indexes are usually not used for ORDER BY or joins: a sequential scan followed by an explicit sort is faster than an indexscan of all tuples of a large table, because it takes fewer disk accesses.

> Hi, > > Indexes are used to find a record faster in a table. > > It only seems to work if I am working with one table. > eg) > > create index customer_id_idx on customer(id); > > select * from customer where id=1; > -- This uses the index I create > > However, when I start to join 2 or more tables together it doesn't seem > to use it.. WHY??? > > eg) > > create index customer_id_idx on customer(id); > > select * from customer, purchaseorder where customer.id=purchaseorder.id; > > -- This results in a seq scan .. WHY?? > > Is there a way to make it so that it uses my index > > Thanks again. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026