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
| | www.bobbydurrettdba.com
Cardinality errors across joins | Bobby Durrett's DBA Blog
2.9 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...
| | iusoltsev.wordpress.com
??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT | Oracle mechanics
3.0 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...
| | blog.jooq.org
What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check
3.0 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
| | yorakb.wordpress.com
Check if PSU is applied | Yorakb
40.9 parsecs away

Travel
| select * from registry$history ;