Home » RDBMS Server » Performance Tuning » Performance tuning a table
Performance tuning a table [message #200371] Mon, 30 October 2006 09:44 Go to next message
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 Go to previous messageGo to next message
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

Re: Performance tuning a table [message #200374 is a reply to message #200371] Mon, 30 October 2006 09:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And
are your statstics upto date?

Report message to a moderator

Re: Performance tuning a table [message #200799 is a reply to message #200371] Wed, 01 November 2006 07:00 Go to previous message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
Consider partitioning the table

Report message to a moderator

Previous Topic: Advice on Hints
Next Topic: Tuning the query - Outer join
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 05:58:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.