Posted by nydefender on 10/14/05 19:01

I have one table with 300,000 records and 30 columns.
For example columns are ID, COMPANY, PhONE, NOTES ...
ID - nvarchar lenth-9
COMPANY - nvarchar lenth-30
NOTES - nvarchar length-250

Select * from database
where NOTES like '%something%'

Is there a way to get results from this query in less then 1-2 second
and how?

• Next in forum: Re: MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
• Prev in forum: Wrong default constraint shown from Object Browser in Query Analyser
• Thread view: MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two

[Reply to this message]