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