Re: [SQL] Using Indexes - Mailing list pgsql-sql

From Chris Bitmead
Subject Re: [SQL] Using Indexes
Date
Msg-id 378AD468.E1EDC26E@tech.com.au
Whole thread Raw
In response to Using Indexes  ("Mr. Poet" <poet@linuxports.com>)
List pgsql-sql
"Mr. Poet" wrote:
> 
> Hello,
> 
> I know how to create and index... but how do I use it?
> >From my old xbase days it was use <index> but that doesn't work
> in postgres... help?

Indexes are used automatically when the database thinks it will speed a
particular query.

I don't know what <index> did in xbase. Did it order things? If you want
ordering see the sql ORDER BY clause.


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] create temp table
Next
From: "Esteban Chiner Sanz"
Date:
Subject: Problem with timestamp and primary key.