Browsing the archives for the NTILE ranking function tag

Testing HASHING to Speed Up Queries on Strings Part I

It’s common knowledge that relational database engines do well indexing numeric data, particularly integer data.  String data is a little more tricky and tends to take longer to search / index. My original intent of this post was to simulate how the SQL Server storage engine might handle statistics on an index, in particular, a [...]

0 Comments