Would never use indexes?

--
iTech Consulting Services Limited
Expert in ePOS (Point-Of-Sales) solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883     Fax: (852)2325 8288

On 7 Jun, 10:24, Man-wai Chang <toylet.toy@gmail.com> wrote:

What makes you think that?

I've just written some dynamic sql that selects data from a 40 million
row table and it's used the index!

Could you provide a scenario to explain your thinking?

Thanks
James