Re: After CREATE INDEX

---- you wrote: > This is a multi-part message in MIME format. > --------------A2D6615A7A4753966A3579C4 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > If I > > CREATE INDEX table_ind ON tableA (col1, col2);> > That means will index col1, col2 in tableA. > But after I index tableA, I do INSERT/UPDATE/DELETE rows > Will also index the col1, col2 in tableA for me? Or I have to > DROP INDEX and CREATE INDEX again? The index is maintained automatically Dude. You do not have to keep re-creating it. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com