OraFAQ Forum: Performance Tuning » Performance tuning a table

Home » RDBMS Server » Performance Tuning » Performance tuning a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance tuning a table [message #200371]

Mon, 30 October 2006 09:44

ezhilv
Messages: 1
Registered: October 2006
Location: Finland

Junior Member

hi,

I am having a table with 4 million records, it is taking lot of time to respond i am not a dba, can anybody guide me to take the necessary performance to improve the performance.

It is taking more 5 mins to respond for a count query.System configurations are very high

Thanks
ezhilv

Report message to a moderator

Re: Performance tuning a table [message #200373 is a reply to message #200371]

Mon, 30 October 2006 09:48

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

It is very difficult to say anything for provide information.
plz. post your query and check excution plan for query then we will give any suggestion on ur query.

hope this clear.

Report message to a moderator