Select vs Choose

[Deskin, Bob]

Mark is correct. The CHOOSE is more effecient for the PRIMARY file. It does
not apply to any other file/table. Remember what we used to teach about
CHOOSE and SELECT. You apply SELECT against CHOOSEn records (pardon the
English). CHOOSE uses the file system or database to do the work, whereas
SELECT is done by QUIZ or QTP.

I'm sure someone will have an exception, but I can't think of any off the
top of my head. And I don't know if this is a "definitive" answer :-)

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


> ----------
> From: 	Michael Lee[SMTP:mcl_systems@bc.sympatico.ca]
> Sent: 	August 30, 1999 11:29 PM
> To: 	stewm@canada.com
> Cc: 	powerh-l@lists.swau.edu
> Subject: 	Re: Select vs Choose
> 
> 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.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.