THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

The need for user-defined index types

This blog has moved! You can find this content at the following new location:

http://greglow.com/index.php/2011/03/10/the-need-for-user-defined-index-types/

Published Wednesday, March 9, 2011 1:59 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

opc.three said:

Indexing calculated columns came to mind as I was reading your article...can you please elaborate on "One alternative is to promote properties of CLR data types via persisted calculated columns and then index those but that's somewhat awkward and more importantly, doesn't really do the same thing."?

March 9, 2011 1:12 PM
 

Greg Low said:

Hi, you can create a persisted calculated column that is based on retrieving a property or calling a method on a UDT. Those properties can then be indexed. While this is tedious to set up, it is useful to a degree. However, it's not the same as being able to index the data type directly. If you consider the spatial data types, ask yourself how much more powerful the spatial indexes are than an index on the lat and long properties.

March 9, 2011 6:40 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement