How to make my quries run fast?
I am using sql server as database to my VB application.
We need to store large data in my tables.
so we used more than one text field in one table.
when i acces data from this table ,it is taking so much time(nearly 1 min) to open the recordset ,even it has only thousands of records.
What stpes has to be follow to speed up my application?
steps already taken
---------
1.Calling only required fields insted all(select *).
2.Not called any text feilds in query.
Please help me.
thanks in advance
srinu
# 1 Re: How to make my quries run fast?
Type your query into query analyzer and choose Index Tuning Wizard from some menu, it should give you quite good suggestions on what indexes to use. But if you need to change data of those indexed columns frequently, then choose carefully what indexes to create, because indexes do speed up queries, but at the same time make updates/inserts/deletes slower.
Another good thing is to use SQL Server Profiler. It records all queries, excecution plans, etc and the data can be later analyzed by Index Tuning Wizard. Start it and at the same time do what you normally would do with your database in production environment. Profiler records everything and Tuning wizard then gives you suggestions.
