On 7 Jun, 10:24, Man-wai Chang <toylet.toy
> 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
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?