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.