Re: Index management

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 11 May 2004 21:11:12 +1000
Message-ID: <40a0b8d1$0$25007$afc38c87@news.optusnet.com.au>

"Mike Ault" <mikerault_at_earthlink.net> wrote in message news:37fab3ab.0405100644.7b46db3e_at_posting.google.com...

> The idea that you should optimize an index for inserts and updates is
> totally odd to me as indexes are used for optimization of select
> processing.

Duh......
an update cannot be performed without an implicit select. indexes are as relevant in an update as in a select...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue May 11 2004 - 06:11:12 CDT