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		jonathanlewis.wordpress.com SQL Profiles - 2 \| Oracle Scratchpad
\|	\|	iusoltsev.wordpress.com FIRST_ROWS CURSOR_SHARING_EXACT \| Oracle mechanics	7.7 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...	7.7 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	8.6 parsecs away Travel
\|	\|	Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...	8.6 parsecs away Travel
\|	\|	tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines? \| Tony's Oracle Tips	8.2 parsecs away Travel
\|	\|	Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...	8.2 parsecs away Travel
\|	\|	blog.toadworld.com Why my execution plan has not been shared - Part I	20.3 parsecs away Travel
\|		Why my execution plan has not been shared - Part I	20.3 parsecs away Travel