Select vs Choose

[Michael Lee]

I would have to agree with you Mark. I think that if you use the CHOOSE statement that it passes this to the relational database as a SQL SELECT statement and only the relevant data gets passed back to QUIZ or QTP.. On the other hand using the SELECT statement means that it is QUIZ or QTP which does the actual selecting instead and, therefore, more overhead. I think we would have to go to Cognos for the definitive answer though.


Michael Lee
MCL Systems Inc.


stewm@canada.com wrote:

> 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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.