Explore >> Select a destination

You are here

 jonathanlewis.wordpress.com
Heisenberg | Oracle Scratchpad
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » GATHER_PLAN_STATISTICS
8.4 parsecs away

Travel
| |
| | rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
9.1 parsecs away

Travel
| | About Oracle
| | iusoltsev.wordpress.com
??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT | Oracle mechanics
8.7 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...
| | nenadnoveljic.com
Performance Improvement on Dictionary Views in Oracle 21c - All-round Database Topics
67.6 parsecs away

Travel
| Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD.