>>>>Well, we know he's got at least an index on ac or the seek wouldn't work, but you're right to check if he's got good indexes.
>>>
>>>Hi Mike,
>>>
>>>We only know that index has name 'ac'. If the key is like 'ac+something' than it'll work for SEEK but not for the query.
>>
>>Yep, that's what I meant. He's got an index called ac.
>
>I see seek is faster even if index optimizable for select. Locate is slower from seek too even for clause full optimizable.
That's been my experience too. However enough looping code with seeks might be slower than one SQL command.
BTW interesting quotation you have there. I've always heard it as:
"The only thing necessary for the triumph of evil is for good men to do nothing" or "Evil thrives when good men do nothing"
One says Edmund Burke said it:
http://www.tartarus.org/martin/essays/burkequote.htmlAnother says he didn't say it:
http://en.wikipedia.org/wiki/Edmund_Burke