General information
Forum:
Microsoft SQL Server
Hi Mike,
When i ran count(*) it gave me result immed. but select * from table still took 46 seconds, when i ran dbcc Showcontig it prints following information
DBCC SHOWCONTIG scanning 'tbl_Application' table...
Table: 'tbl_Application' (500912856); index ID: 1, database ID: 13
TABLE level scan performed.
- Pages Scanned................................: 466
- Extents Scanned..............................: 60
- Extent Switches..............................: 60
- Avg. Pages per Extent........................: 7.8
- Scan Density [Best Count:Actual Count].......: 96.72% [59:61]
- Logical Scan Fragmentation ..................: 88.20%
- Extent Scan Fragmentation ...................: 11.67%
- Avg. Bytes Free per Page.....................: 2389.6
- Avg. Page Density (full).....................: 70.48%
DBCC execution completed. If DBCC printed error messages, contact your system administrator
in which area i will check for this ?
Thanks for ur all help.
...ashish
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only