Disk Reads:

Hi,
Recently I created 2 partitioned tables and now the disk reads of these partitioned tables are going as high as
3296823 and 1432681.

I created the partitioned tables, created the indexes on them and then imported the data into these tables.
Does it mean that I have to rebuild the index. and doing so will my disk reads comedown.

Badrinath

Disk reads mainly depends upon the query that requests the data from the table. It is advisable to create indexes on a table after importing the data, not before.

Increase the db_file_multiblock_read_count to 16 and see how it performs.


SQLPLUS SYS/password@service_name
alter system set db_file_multiblock_read_count=16;

exit


I hope that this would help to an extent.

Sam