Explore >> Select a destination
|
You are here 
|
blog.yannickjaquier.com | ||
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | I was working on the example from an earlier blog post that showed how the optimizer could not correctly estimate the number of rows accessed on a table if the non-join condition was on a different... | |
| | | | |
sqlmaria.com
|
|
| | | | | In a recent chat with Connor McDonald, we discussed if it is realistic to have applications that don't contain Optimizer hints. Ideally, the answer to this question is "yes", you don't need hints i... | |
| | | | |
andreabergia.com
|
|
| | | Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without. | ||
