Re: Tuning 'Alter Modify" column

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 24 Aug 2022 21:46:43 -0400
Message-ID: <dd3a4339-6bde-711e-5973-a96b9529220c_at_gmail.com>

And also during the table scan i was seeing event 'cell singleblock physical read'

Single block physical read is usually an index read. You cannot have index read if you want to do it fast. You need to find out where are those index reads coming from.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

-- http://www.freelists.org/webpage/oracle-l Received on Thu Aug 25 2022 - 03:46:43 CEST