USING INDEX

From: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
To: pgsql-sql(at)postgresql(dot)org
Subject: USING INDEX
Date: 2003-01-29 07:27:18
Message-ID: 3E378256.BF72E1E8@mimos.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How do we determine which column/s to be set when creating an INDEX?
As I understand, using INDEX the query will be more faster then without
using INDEX.
How about using INDEX if query is a JOIN query, which involved 4 tables.

Browse pgsql-sql by date

  From Date Subject
Next Message Sondaar Roelof 2003-01-29 08:05:52 COPY use in function with variable file name
Previous Message Stephan Szabo 2003-01-29 06:44:57 Re: Creating tables from within functions