Thread: INDEX
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?
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