Postgres Pro
Downloads
Home   >   mailing lists

USING INDEX - Mailing list pgsql-sql

From Abdul Wahab Dahalan
Subject USING INDEX
Date
Msg-id 3E378256.BF72E1E8@mimos.my
Whole thread Raw
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Creating tables from within functions
Next
From: Bruno Wolff III
Date:
Subject: Re: Cross-table constraints