HI ,
We have a table which has about close to 8 billion records and we are inserting about close to 70 million records everyday. We partitoned this table on date column based on everyday. And we also we have indexed 3 columns.
My concern, not matter what how effieicient SQL u write to query this table, it takes huge amout of time.
My concern, not matter what how effieicient SQL u write to query this table, it takes huge amout of time.
I have couple of questions
------------------------------------
-Is ther is any way we make this table more efficient ?? do we have any options left ??
- Since bcoz of huge volume, do we need to query this table based on a single partition every time ?? ex :- like single day or a week , not complete table right ??
fyi - version - oracle 11g
thank you so much !!