This thread is about Menus and in that context what James says is true.
However, because you (Guillermo) used the phrase "Run If" in your email, it makes me think that you are thinking of Active Links and Filters (or maybe Escalations). Since Active Links and Filters basically operate on individual records, using a LIKE in the "Run If" of these won't cause a table scan - its just pattern matching on the current record. Escalations could cause a table scan. Its often easy to get caught up in the "does this cause a table scan" debate/consideration and forget that the thing you are working on only pertains to a single record at any given time.
Cheers,.
Thad
"Argue for your limitations, and sure enough, they're yours."-- Richard Bach
| "McKenzie, James J
C-E LCMC HQISEC/L3" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/31/2006 05:59 AM
|
|
**
Alfredo:
Yes. LIKE will force a full table scan as you are looking for part
of a word. HOWEVER, that being said, Group is much different as the
text value is converted into a numeric and then searched for. This
may NOT force a table scan but I don't know if you indexed the field so
I don't know if it would use it in your case.
James McKenzie
L-3 GSI
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Guillermo Alfredo Torres Barron
Sent: Monday, October 30, 2006 5:45 PM
To: [email protected]
Subject: Re: QUESTION: MENU - NOT LIKE
**
I use this qualification
$GROUPS$ LIKE "%Administrator%"
Work good ;)
A question, somebady I said me that if I can use LIKE in a Run if quealification I do a FULL SCAN over database, It is true?
Thanks in advance
__20060125_______________________This posting was submitted with HTML in it___
***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.***
