Certain Find Criteria Slows down find
We have an "item" field that may contain part numbers (ex: CTC2410-R or CES-3R-3716). The "item" field is indexed and there are about 250,000 records in this database.
If we search on the "item" field using only characters, the results return almost instantaneously! Ex: CTC2410
However, if we search using a dash (or hyphen), it slows down the find tremendously, sometimes almost 30 seconds to return the results. Ex: CTC2410-R
Am I missing something or is there something I do not know about that would be causing this search to bog down?
Thanks in advance.