Reply to Mini Index?

Your name:

Reply:


Posted by paulmac106 on 09/29/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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация