Index Organization

Think of the indexes you might see in your everyday life–those in books and other documents. In this era of massive amounts of online information and extremely fast online search engines, it’s probably rare that you actually open a book to look for information, so you might have to stretch your imagination a bit to follow my analogy here. But assume that all you have is printed reference materials. Suppose that you’re trying to create a view in SQL Server using the CREATE VIEW statement and you’re using two SQL Server references to find out how to write the statement. One document is a Microsoft SQL Server 2005 Transact-SQL Language Reference Manual. The other is Inside Microsoft SQL Server 2005: T-SQL Programming. You can quickly ...

Get Inside Microsoft® SQL Server™ 2005, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.