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,
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