Select vs Choose

[stewm@canada.com]

I was recently in a debate at work about whether it was better to put selection criteria values in the CHOOSE or the SELECT.  The debate was if the item in the CHOOSE statement is not in the index of the table that it has no benefit over coding it in the SELECT statement.  I was always under the understanding that if can put it in the CHOOSE then do so.  What difference does it make if the item is in the index?  Does it still speed things up using a CHOOSE even if the item is not a part of an index?  I thought the CHOOSE would do everything at the database level and ,not matter what, retreival would be faster.  The are a few people that think otherwise.

Mark Stewart
Consultants Club
Windsor, Ontario

----------------------------------------------------------
Get your FREE personalized e-mail at http://www.canada.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.