Home » RDBMS Server » Performance Tuning » Performance Tuning
Performance Tuning [message #272221] Thu, 04 October 2007 04:45 Go to next message
ramakrishnakapilavai
Messages: 1
Registered: October 2007
Location: mumbai
Junior Member
A query when run in one database uses indexes, and when the same is run on other database doesnot, the cost and cardinality are very high in this case.
Re: Performance Tuning [message #272227 is a reply to message #272221] Thu, 04 October 2007 04:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you analyze the objects?
Re: Performance Tuning [message #272228 is a reply to message #272221] Thu, 04 October 2007 04:54 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't you see there is a forum with the same name of your topic?
2/ Don't you see OraFAQ Forum Guide?
3/ Don't you see How to Identify Performance Problem and Bottleneck in Peformance Tuning forum?

Regards
Michel
Previous Topic: Optimizing Oracle SQL statements - can anyone help?
Next Topic: sql query optimization
Goto Forum:
  


Current Time: Wed Dec 07 06:29:14 CST 2016

Total time taken to generate the page: 0.10094 seconds