Home » RDBMS Server » Performance Tuning » Index hint inside the view is not working (ORACLE 10g, AIX)
icon3.gif  Index hint inside the view is not working [message #295914] Wed, 23 January 2008 22:21 Go to next message
junaidsystems
Messages: 30
Registered: June 2006
Member
Hi,

I have put an index hint on a query which is working fine and fast, but when I put it inside the view and call it from a stored procedure then it takes time and shows a full table scan in query plan.

Any help will be appriciated.

regards,


Re: Index hint inside the view is not working [message #295957 is a reply to message #295914] Thu, 24 January 2008 00:40 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post a test case.
As usual for a performances question you have to post all information concerning table, index, number of rows (total and in each indexed columns) and so on.

Regards
Michel
Previous Topic: Reproduce performance problem in test
Next Topic: Insert using DB Link (merged)
Goto Forum:
  


Current Time: Sat Dec 10 12:32:53 CST 2016

Total time taken to generate the page: 0.08252 seconds