Re: difference between access times of SELECT and UPDATE

"Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message news:<a9jcug$3ltol$1_at_ID-70985.news.dfncis.de>...
> Hallo all!
>
> can somebody explain me the difference between access times of SELECT and
> UPDATE,
> which use the same index? I get:
>
> by SELECT:
>
> Execution Plan
> ----------------------------------------------------------
> 0 SELECT STATEMENT Optimizer=CHOOSE
> 1 0 INDEX (RANGE SCAN) OF 'I11_BBEWV2' (NON-UNIQUE)
>
> Statistics
> ----------------------------------------------------------
> 0 recursive calls
> 0 db block gets
> 3 consistent gets
> 2 physical reads
> 0 redo size
>
> by UPDATE
>
> Execution Plan
> ----------------------------------------------------------
> 0 UPDATE STATEMENT Optimizer=CHOOSE
> 1 0 UPDATE OF 'BBEWV2'
> 2 1 INDEX (RANGE SCAN) OF 'I11_BBEWV2' (NON-UNIQUE)
>
> Statistics
> ----------------------------------------------------------
> 2 recursive calls
> 394 db block gets
> 11203 consistent gets
> 11203 physical reads
> 113672 redo size
>
> Thanks
> Andrei

The statistics of the actual update are reflected in the explain plan. As you don't provide your statement my suggestion is your table is heavily indexed.This has nothing at all to do with your index access.

--
Regards

Sybrand Bakker
Senior Oracle DBA