Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some questions on indexes
"Frank Zimmer" wrote...
> 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
Hallo Frank,
the indexes will be up to date automatically, you don't have to do anything. Since you mention that you're a beginner, I would advise you to do some reading in the documentation set. Maybe the concepts first. When you finished that you will have a general understanding about your RDBMS and how it works.
A number one address is: http://otn.oracle.com/index.html For searches on given topics try: http://tahiti.oracle.com/
hth,
Guido
Received on Thu Mar 25 2004 - 05:35:55 CST