/explore
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
savvinov.com
In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it's probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I will discuss frequently used options and some common problems. Preparation... |
|
| | | | | ||
| | | | |
optimizermagic.blogspot.com
Generating and displaying the execution plan of a SQL statement is a common task for most DBAs, SQL developers, and preformance experts as i... |
|
| | | | | ||
| | | | |
www.xt-r.com
|
|
| | | |||
