OraFAQ Forum: Performance Tuning » Index hint inside the view is not working

Home » RDBMS Server » Performance Tuning » Index hint inside the view is not working (ORACLE 10g, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index hint inside the view is not working [message #295914]

Wed, 23 January 2008 22:21

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,

Report message to a moderator

Re: Index hint inside the view is not working [message #295957 is a reply to message #295914]

Thu, 24 January 2008 00:40

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 18:33:42 CDT 2024