Posted by paulmac106 on 11/23/74 11:33

I have a table with a few million records and I need to search and
return rows where a varchar(1000) field has the value "Showed"

SQL will not allow me to add an index for a field of this length.

Is it possible to create some kind of index for only the value "Showed"


Or is there some other faster way to search for this value?

thanks,
Paul

• Next in forum: Planning multiple queries
• Prev in forum: Re: Select *
• Thread view: Mini Index?

[Reply to this message]