Implementing A Hash Partition In SQL Server 2005

re: Implementing A Hash Partition In SQL Server 2005

Adam Machanic — Mon, 21 Apr 2008 22:22:43 GMT

The only problem with doing something like this is that every one of your queries against the partitioned table is going to have to know the algorithm in order to produce a predicate that can be matched for partition elimination. If the engine would do this hashing work for us it could encapsulate all of that logic... I'm not sure why this capability was removed from the list for both 2005 and 2008 -- at least on the surface, it certainly doesn't seem difficult to implement!

re: Implementing A Hash Partition In SQL Server 2005

KKline — Thu, 24 Apr 2008 13:59:38 GMT

Ah, I didn't think of that!

And you're right, it should be easy to do. Both Oracle and DB2 have hash partitions in the box.

re: Implementing A Hash Partition In SQL Server 2005

ZZ — Sat, 16 Apr 2011 03:49:03 GMT

If a table has one & only one Column.

In which normal form we can categorize that table ?

Tuning indexes | Ideas, Knowledge y Tecnolog??a

Tuning indexes | Ideas, Knowledge y Tecnolog??a — Fri, 03 May 2013 06:28:43 GMT

PingBack from http://metodoikt.wordpress.com/2013/05/01/tuning-indexes/