Hi Guys,

I am working on a database which has 65 million rows into it. It is a fact table. I have created the indexes and primary keys for the fact table. But it is taking time to run the queries. i want to improve its performance. I want to do performance tuning of this database. Any suggestions regarding performance tunning. How can i improve the performance of my database. I am using oracle 10g

I am a fresher in the DBA field. So any suggestions will be really appreciated.


Thanks