DBCC
From: Rena (Rena_at_mail.hongkong.com)
Date: 10/19/04
- Next message: Rick Sawtell: "Re: If row exists update row, else insert row"
- Previous message: ChrisR: "Re: dbcc dbreindex problems"
- Next in thread: Tom Moreau: "Re: DBCC"
- Reply: Tom Moreau: "Re: DBCC"
- Reply: David Gugick: "Re: DBCC"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 20 Oct 2004 01:26:51 +0800
Hi all expert,
I have a question about the below result.
why 416 rows only in 7 pages , but 231 rows need 9 pages on those
particular table?
what does this imply? query sysobjects need less time then sysindexes?
....and what information are implied?
Thanks alot.
Rena.
DBCC results for 'PCISDEV'.
DBCC results for 'sysobjects'.
There are 416 rows in 7 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 231 rows in 9 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 5613 rows in 91 pages for object 'syscolumns'.
DBCC results for 'systypes'.
- Next message: Rick Sawtell: "Re: If row exists update row, else insert row"
- Previous message: ChrisR: "Re: dbcc dbreindex problems"
- Next in thread: Tom Moreau: "Re: DBCC"
- Reply: Tom Moreau: "Re: DBCC"
- Reply: David Gugick: "Re: DBCC"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
