Re: [SQL] Using Indexes

From: Chris Bitmead <chris(at)tech(dot)com(dot)au>
To: poet(at)linuxports(dot)com
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Using Indexes
Date: 1999-07-13 05:53:44
Message-ID: 378AD468.E1EDC26E@tech.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Esteban Chiner Sanz 1999-07-13 07:14:23 Problem with timestamp and primary key.
Previous Message Mr. Poet 1999-07-13 05:10:19 Using Indexes