Thread

1. INDEX

   Waruna Geekiyanage <waruna@nirmani.com> — 2002-09-28T15:50:13Z

   When a table is created with a primary key it generates a index.
   Dos the queries on that table use that index automatically?
   Do I need to reindex that index after insertions?
   

2. Re: INDEX

   Andrew Sullivan <andrew@libertyrms.info> — 2002-09-28T19:13:18Z

   On Sat, Sep 28, 2002 at 09:50:13PM +0600, Waruna Geekiyanage wrote:
   > When a table is created with a primary key it generates a index.
   > Dos the queries on that table use that index automatically?
   
   Only if you analyse the table, and it's a "win".  See the various
   past discussion on -general, for instance, about index use, and the
   FAQ.
   
   > Do I need to reindex that index after insertions?
   
   No, but you need to analyse.
   
   A
   
   -- 
   ----
   Andrew Sullivan                         204-4141 Yonge Street
   Liberty RMS                           Toronto, Ontario Canada
   <andrew@libertyrms.info>                              M2P 2A8
                                            +1 416 646 3304 x110