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 Push Group by \| Oracle Scratchpad
\|	\|	iusoltsev.wordpress.com FIRST_ROWS CURSOR_SHARING_EXACT \| Oracle mechanics	1.6 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...	1.6 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	2.1 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...	2.1 parsecs away Travel
\|	\|	blog.sqlora.com Fix Optimizer Estimate Issues from Implicit Conversions #JoelKallmanDay	2.5 parsecs away Travel
\|	\|	Learn how implicit RAW-to-VARCHAR2 conversions in Oracle break histograms, hurt optimizer estimates, and how to fix them safely.	2.5 parsecs away Travel
\|	\|	iggyfernandez.wordpress.com The golden rule of NOT tuning SQL \| So Many Oracle Manuals, So Little Time	19.2 parsecs away Travel
\|		Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:...	19.2 parsecs away Travel