|
|
|
|
|
|
|
|
|
|
| Re: Hints within a query that reads from view [message #425197 is a reply to message #425192] |
Thu, 08 October 2009 00:25   |
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
|
Member |
|
|
I read this article somewhere,
FYI,
Hints and Complex Views
By default, hints do not propagate inside a complex view. For example, if you specify a hint in a query that selects against a complex view, then that hint is not honored, because it is not pushed inside the view.
Note:
If the view is a single-table, then the hint is not propagated.
Unless the hints are inside the base view, they might not be honored from a query against the view.
To summarize, Oracle views are an encapsulation of a complex query and must be used with care. Here are the key facts to remember:
Views are not intended to improve SQL performance. When you need to encapsulate SQL, you should place it inside a stored procedure rather than use a view.
Views hide the complexity of the underlying query, making it easier for inexperienced programmers and end users to formulate queries.
Views can be used to tune queries with hints, provided that the view is always used in the proper context.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
