Received: from localhost.localdomain (h246.ozemail2.ozemail.com.au [203.108.14.246]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA10930 for ; Tue, 13 Jul 1999 01:54:10 -0400 (EDT) (envelope-from chris@tech.com.au) Received: from tech.com.au (localhost [127.0.0.1]) by localhost.localdomain (8.9.3/8.9.3) with ESMTP id PAA12520; Tue, 13 Jul 1999 15:53:44 +1000 Sender: chris@localhost.localdomain Message-ID: <378AD468.E1EDC26E@tech.com.au> Date: Tue, 13 Jul 1999 15:53:44 +1000 From: Chris Bitmead X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.6 i686) X-Accept-Language: en MIME-Version: 1.0 To: poet@linuxports.com CC: pgsql-sql@hub.org Subject: Re: [SQL] Using Indexes References: <199907130516.WAA16659@ezwebhost.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit "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 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 did in xbase. Did it order things? If you want ordering see the sql ORDER BY clause.