Gail,

Here is the all details;

DBCC SHOWCONTIG scanning 'Employee' table...

Table: 'Employee' (901578250); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 8

- Extents Scanned..............................: 4

- Extent Switches..............................: 3

- Avg....

Ron,

Yes, I have clustered index on that table.

Thanks,

Pinakin