Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » Do SQL Plan Baselines Use Hints?
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	1.9 parsecs away Travel
\|	\|	The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating...	1.9 parsecs away Travel
\|	\|	leonotes.wordpress.com (transitive closure)?(Constraint-Generated Predicates) \| LEO Notes	2.1 parsecs away Travel
\|	\|	transitive closure?Wiki?Oracle?...	2.1 parsecs away Travel
\|	\|	savvinov.com Global Hints - Oracle Diagnostician	2.9 parsecs away Travel
\|	\|	Occasionally I encounter a situation when I need to affect a part of the plan that corresponds to a view, e.g.: Such situations are resolved using global hints. Oracle offers two ways to specify a global hint: via a query block identifier (system generated or user defined) or via view aliases. System-generated query block identifiers...	2.9 parsecs away Travel
\|	\|	iusoltsev.wordpress.com FIRST_ROWS CURSOR_SHARING_EXACT \| Oracle mechanics	17.0 parsecs away Travel
\|		465 ?! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%?%' OR A.LASTNAME LIKE '%?%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ?, ? ? A.COMPANY_ID = 1 ? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT...	17.0 parsecs away Travel