VMS 6.2, Dec Rdb V6.1-13, Powerhouse 7.10E6

[Penney, John]

Powerhouse Listers:
   
  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?
   
  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?
   
  Would somebody please share with me their experiences in these instances.
   
  Many thanks!
   
  JP in IL

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080422/619b397c/attachment.htm