Outer Web | Explore

Explore >> Select a destination

You are here		antognini.ch V$SQL_CS_HISTOGRAMS: What Are the Buckets' Thresholds? - Striving for Optimal Performance
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	7.3 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.3 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com dbms_xplan in 10g \| Oracle Scratchpad	8.6 parsecs away Travel
\|	\|	[More on dbms_xplan.display_cursor()] If you're using 9i and haven't learned about the dbms_xplan package, then you should take a good look atit right away. It's(usually) a much better wayof getting execution plans from your system thanwriting yourown queries against the plan_table. If you'vebeen using dbms_xplan, and upgraded from 9i to 10g, make sure that you...	8.6 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	7.8 parsecs away Travel
\|	\|	????????transitive closure?Wiki??????????Oracle????????...	7.8 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	44.0 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...	44.0 parsecs away Travel