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.

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
Did you analyze the objects?

Report message to a moderator

Re: Performance Tuning [message #272228 is a reply to message #272221] Thu, 04 October 2007 04:54 Go to previous message
Michel Cadot
Messages: 68664
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 25 20:15:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.