I have a database in MSSQL 7.0. The database has around 10 tables of which the mainly working tables are just 3.
The first table contains around 900 records
the Second table contains around 100000 records
and the third table contains around 400000 records.|
The third table has a text datatype filed
all three tables are indexed on the primary fields.
When ever i try to use a join query picking up information from all three tables and a like crieteria used on the text datatype field on the third table, the query goes beyond 3 - 4 minutes in Query Analyser however the VB tool gives runtime error SQL Server Time Out.
How can this be solved.