Outer Web | Explore

Explore >> Select a destination

You are here		www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	0.9 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	0.9 parsecs away Travel
\|	\|	connor-mcdonald.com Kris Kringle the Database - Getting the BAND together - Learning is not a spectator sport	1.5 parsecs away Travel
\|	\|	Ever heard of a BAND join? It's not actually new, it has been around since 12.2. Jonathan Lewis wrote up a nice post on it was back in 2017 but in a nutshell MERGE join done without a band join SQL> select 2 e1.last_name\|\| ' has salary roughly between '\|\| e2.last_name comparison 3 from 4...	1.5 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	1.4 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.4 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	21.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...	21.9 parsecs away Travel