Friday, August 14, 2009

Creating indicies on views

Because runsaturday maintains two user databases - one for yaf and one for dnn - I wanted to create a lookup table from one set of userids to the other.

And the easiest way of doing this automatically was a view with an index.

But to create the index on the view - I had to remember the SchemaBinding trick - see http://www.mssqltips.com/tip.asp?tip=1610 for more information about schema bound views.

No comments:

Post a Comment