Hi. I have an SQL 2000 database. Mytable1 and Mytable2 both have approximatey the same number of records.. roughly 1 million records.
MyTable1 was created and set up by a software that we use.
MyTable2 was created by importing a comma delimited text file.
When I select * from MyTable1 where bookno = '3', the six resulting rows show up in less than a second.
When I select * from MyTable2 where bookno = '3', the six resulting rows show up in about 4 minutes.
I tried running DBCC DBREINDEX (MyTable2, '', 70), which completed in less than a second, but it still didn't help.
Any idea what I can look for as a difference between MyTable1 and MyTable2 so I can replicate and make MyTable2 select statements run faster?
MyTable1 was created and set up by a software that we use.
MyTable2 was created by importing a comma delimited text file.
When I select * from MyTable1 where bookno = '3', the six resulting rows show up in less than a second.
When I select * from MyTable2 where bookno = '3', the six resulting rows show up in about 4 minutes.
I tried running DBCC DBREINDEX (MyTable2, '', 70), which completed in less than a second, but it still didn't help.
Any idea what I can look for as a difference between MyTable1 and MyTable2 so I can replicate and make MyTable2 select statements run faster?