>>OK, one last question, can you post a screen shot of your execution plan?
>>
>>I created a test table and with the same query, I'm getting a pretty simple plan, but I might be missing something.
>
>Here it is.
Yup, that's the same plan I'm getting.
I'm sure there's a reason, but I'll ask - why the text index on VehicleModel but not on VehicleMake?