3 ms·
In principle yes, it is even mentioned in footnotes of the matrix (2, 3).
by MarkusWinand 8y ago
In principle yes, it is even mentioned in footnotes of the matrix (2, 3).
- taspeotis 8y agoThank you for compiling the matrices. I think "Parameters in Fetch First|Next" is wrong with regards to SQL Server, it supports "Parameters (?) in fetch first" [1]. [1] https://docs.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql?view=sql-server-2017#b-specifying-variables-for-offset-and-fetch-values https://docs.microsoft.com/en-us/sql/t-sql/queries/select-or...
- MarkusWinand 8y agoVery well spotted! I've just fixed that. One of my test cases was binding that paramter as 'numeric' rather than 'interger'. The other DBs didn't care about that.
- boshomi 8y ago@MarkusWindand: Thank you for the Websites [1],[2],[3] and the book »SQL Performance Explained«[4]. [1] https://modern-sql.com/ https://modern-sql.com/ [2] https://use-the-index-luke.com/ https://use-the-index-luke.com/ [3] https://db-engines.com/ https://db-engines.com/ [4] https://www.amazon.de/SQL-Performance-Explained-Everything-performance/dp/3950307826/ https://www.amazon.de/SQL-Performance-Explained-Everything-p...
- MarkusWinand 8y agoWelcome. But db-engines.com is not my site (but also run by Austrians ;)