Hi,
I am having a table which is having around 170 Columns(Don't blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there any way I can make this query to run faster.Thanks In Advance - Sachin
There is around 1000 records only.and Latency is
Pinging [172.30.5.48] with 32 bytes of data:
Reply from 172.30.5.48: bytes=32 time=218ms TTL=122
Reply from 172.30.5.48: bytes=32 time=218ms TTL=122
Reply from 172.30.5.48: bytes=32 time=221ms TTL=122
Reply from 172.30.5.48: bytes=32 time=218ms TTL=122
Try Select * from Table with (nolock) - if this runs faster then the issue is not indexes etc but locking. If it is still slow try defragmenting table and its indexes. Also such a large number of columns shows lack of normalisation and are you sure you need: Select * from table without restricting which columns or using a where statement to restrict which rows? I would look at the whole design issue and try to improve table and query structure.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 3  Replies