sql query not use index

From: <sydneypuente_at_yahoo.com>
Date: Mon, 9 Mar 2009 11:11:31 -0700 (PDT)
Message-ID: <d70b919e-5490-4dd3-95c9-4717bdf8e8fc_at_q18g2000vbn.googlegroups.com>

Hello Guys,

I was asked yesterday a project manager what sort of query will not use an index?
What sort of index ? I asked
say a varchar(256) ?
A badly written regex. I responded.
OK thanks.

Now I am worried I have given a misleading or wrong response! Can anyone help me out with a better answer?

TIA Syd Received on Mon Mar 09 2009 - 13:11:31 CDT

Original text of this message