Outer Web | Explore

Explore >> Select a destination

You are here		nenadnoveljic.com A Data Model Fix for Suboptimal Semi-Join and Anti-Join Cardinality Estimates - All-round Database Topics
\|	\|	blog.jooq.org What's faster, COUNT() or COUNT() with LIMIT in SQL? Let's check	9.3 parsecs away Travel
\|	\|	We check execution plans and benchmark results to see if using a LIMIT clause is useful when checking for existence of N values in SQL	9.3 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	9.8 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...	9.8 parsecs away Travel
\|	\|	www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog	9.2 parsecs away Travel
\|	\|	We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...	9.2 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	34.1 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...	34.1 parsecs away Travel