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
Messages: 30
Registered: June 2006

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.


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: 63915
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.

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

Current Time: Mon Oct 24 11:10:34 CDT 2016

Total time taken to generate the page: 0.12317 seconds