Outer Web | Explore

Explore >> Select a destination

You are here		use-the-index-luke.com GROUP BY??????????
\|	\|	dioncho.wordpress.com _gby_hash_aggregation_enabled bug \| Dion Cho - Oracle Performance Storyteller	9.4 parsecs away Travel
\|	\|	One of the customers complained that Oracle refuses to use the HASH GROUP BY operation under any circumstances. It's 10gR2(10.2.0.1) database. See that Oracle simply refuses to use HASH GROUP BY operation even with the simplest group by? You might think that the "_gby_hash_aggregation_enabled" would have been false which is clearly right. But even with...	9.4 parsecs away Travel
\|	\|	leonotes.wordpress.com ????(transitive closure)????????(Constraint-Generated Predicates) \| LEO Notes	11.4 parsecs away Travel
\|	\|	????????transitive closure?Wiki??????????Oracle????????...	11.4 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	13.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...	13.6 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	27.9 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...	27.9 parsecs away Travel