Re: Some questions on indexes

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Thu, 25 Mar 2004 11:31:46 GMT
Message-ID: <Cqz8c.124246$Wa.19008@news-server.bigpond.net.au>

"Frank Zimmer" <frank.zimmer_at_euroscript.lu> wrote in message news:c3uf09$2bm131$1_at_ID-105697.news.uni-berlin.de...
> Hi,
>
> i'm an oracle beginner.
>
> When i create an index on a table, and add delete update this table.
> Is then the index also updated or do i have to do this by hand ?
> Using Oracle 9i
>
> Best Regards
> Frank

Frank,

The indexes are updated automatically unless they are UNUSABLE.

I suggest you read the Database Concepts manual.

Douglas Hawthorne Received on Thu Mar 25 2004 - 05:31:46 CST