Hekaton Part 5: Introduction to Indexes in In Memory Tables
After a short little break on Hekaton series, we are now back with the 5th post. Two new index types have been introduced. They are 1) Has...
Read More
Tampilkan postingan dengan label Indexing. Tampilkan semua postingan
Tampilkan postingan dengan label Indexing. Tampilkan semua postingan
Hekaton Part 6:- Hash Indexes - Intro
With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would help understanding...
Read More
Hekaton Part 7 - Hash Collisions & Hash Buckets
As explained in the earlier post , a hash index places pointers to the rows in hash buckets, depending upon the value returned by hash func...
Read More
Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV
Continuing from previous post , this post will discuss a few scenarios on hash collisions. The following "in memory" tabl...
Read More
Hekaton Part 9: Things Hash Indexes can't do
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What are things hash indexes c...
Read More
Hekaton Part 10: Things Hash Indexes Can do
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on hash algorithm ...
Read More
Residual Predicate and Number of Rows Read in Execution Plans
What is Residual Predicate? Lets say one gets a query to fine tune. While checking the execution plan, if there is a Index seek, it is c...
Read More
Langganan:
Postingan (Atom)