A view usually contains a mix of key and result data items. This mixture of keys and results provides flexibility in determining the amount of detail of the data to be returned. The exception is server-wide data, such as transaction or network activity data. For server-wide data, no key data items are specified and only one row of data is returned.
Table 2-1 shows examples of data returned by views.
View defined with |
Returns |
---|---|
SMC_NAME_PAGE_IO |
page I/Os for the whole server Row results: Page I/O --------- 145 |
SMC_NAME_SPID, SMC_NAME_LOGIN_NAME, SMC_NAME_PAGE_IO (where SPID is a key data item) |
page I/O per process Row results: SPID Login Name Page I/O --------------------------- 3 sa 45 5 joe 100 |
SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_DB_NAME, SMC_NAME_OBJ_NAME, and SMC_NAME_PAGE_IO (where SMC_NAME_SPID, SMC_NAME_DB_ID, and SMC_NAME_OBJID are key data items) |
page I/O per database table per process Row results: SPID DBID ObjID DBName ObjName PageIO ------------------------------------------------ 1 5 208003772 pubs2 titles 10 1 5 336004228 pubs2 blurbs 5 5 5 22003430 pubs2 sales 100 |