Re: INDEX

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