|
You are here |
www.dbaglobe.com | ||
| | | | |
oracle-randolf.blogspot.com
|
|
| | | | | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these... | |
| | | | |
iusoltsev.wordpress.com
|
|
| | | | | ??????? ?????? ?? ??????? ??????????? 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... | |
| | | | |
leonotes.wordpress.com
|
|
| | | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | | |
tanelpoder.com
|
|
| | | Training overview This training session is entirely about making Oracle SQL execution run faster and more efficiently, understanding the root causes of SQL performance problems and Cost Based Optimizer misbehavior. Instead of looking into increasing system utilization (by using more buffer cache or more parallelism) as a first "tuning" choice, this class is mostly about decreasing resource usage of SQL execution plans by improving their shape and available access paths. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing. | ||