Say I have a table with column A, B, C, D
A has a unique index on it (primary key)
B and C have a normal index on it
D has no index

If I perform a query like update tbl set D = 'whatever' ;
that should make no difference on the indexes on the other columns, right ?

Or is there some kind of mechanism that does create a sort of new record, thus makes the indexes go wild.

Met vriendelijke groeten,
Bien à vous,
Kind regards,

Yves Vindevogel

TIFF image

Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91

Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76

Web: http://www.implements.be
First they ignore you. Then they laugh at you. Then they fight you. Then you win.
Mahatma Ghandi.</x-tad-smaller>
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to