what tuning options to improve query efficiency when rows grow by millions?
thomas kJul 27 2010 — edited Jul 28 2010Hi all,
i have a database with one of the tables growing by 4 million rows per year. Currently it has 18 million rows. the table is not partitioned on any column. i have been adding datafiles to the database tablespaces to allocate more free space to the database.
i would like to know, whether it is sufficient to just add the datafiles to maintain performance of queries or if i have to do something else like memory management or something else to improve speed of getting query results, speedy updation, insert,delete operations.
kindly specify each step i have to take in this direction.
yours sincerely
thomas k prakash