Chapter 3 Building Physical Diagrams


Defining an index in a query table

You can create an index associated with the columns of a query table. In this section, these indexes are called view indexes. Query table indexes behave like indexes defined on tables, they are data structures that improve database performance and access speed. You normally create indexes for columns that you access regularly, and where response time is important.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.