Table size is too big Performance issue.
728256Jan 26 2010 — edited Jan 27 2010Hi,
Let us assume that we have table which has about 160 columns in it. About 120 of these columns are Varchar data type with about 100-3000 size each column.
This table also has about 2 Millions Rows in it. I am not sure if these are considered as big sized tables?
Does tables like these a good representation of data. I am in doubt as the size of the table is very big and might take long time for queries. We have about 10 indexes on this table.
What kind of precautions have to be taken when these kind of tables are involved in the database and they required for the application.
Database version is Oracle 10.2.0.4
i know the question is bit vague, but i am just wondering what needs to be done , and from where i have to start to dig into the issue just in case I get performance issues while trying to select the data or update the data.
i also want to know if there is any idle size for the tables and any thing that is more than that needs to be treated differently.
Thanking you
Rocky