Thread: Using Indexes

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?

{poet}  --poet@linuxports.com--ICQ: 33017215      --http://www.linuxports.com-- 
Author: Consultants, Commercial, VAR Howto Visit the LDP: http://www.linuxdoc.org

"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.