<div>Powerhouse Listers:</div> <div> </div> <div>Working on a system with the above parameters. Yes, not supported, but I digress. I am analyzing some performance issues and need some advice regarding CHOOSE on a non-keyed field (column) which one can do because it's a relational database. Can one expect a significant improvement in performance if said column was declared as an Index?</div> <div> </div> <div>In adhoc tests I have found about a 10% improvement in throughput using a CHOOSE on a non-Indexed column versus a SELECT. What can I expect if it's Indexed?</div> <div> </div> <div>Would somebody please share with me their experiences in these instances.</div> <div> </div> <div>Many thanks!</div> <div> </div> <div>JP in IL</div><p> 
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>