Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
netstring
Starting Member
1 Post |
 Posted - 2010-06-05 : 06:22:52
|
| HiIn SQL Server 2005 I have a sample table with 4 columns and 195433 records. 3 columns is full text indexed.When i run the following query in SQL 2005 the execution completes in 4 seconds.use testdeclare @find varchar(50);set @find= 'area1 | area2 | area3';select * from dbo.tablename1 where (@find=' " " ') OR contains (addr, @find) Later, i restored the above table in SQL server 2008 and rebuild the index.When i run the above query it takes 32 seconds for the execution to complete.if i replace the following select * from dbo.tablename1 where (@find=' " " ') OR contains (addr, @find) TOselect * from dbo.tablename1 where (' "" ' = ' " " ') OR contains (addr, @find) Then result is displayed in 3sec in SQL server 2008Can someone please tell me why it takes more time for execution in SQL server 2008.Is there any issues relating to variable execution in SQL server 2008Both the instaces of SQl(2005 & 2008) are installed on the same machineThank you |
|
|
|
|
|
Slow query excution in server 2008