-
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