Thad:
Thank you for the clarification. I will add that if you are looking for items in a Push/Set Fields within a filter, you can force a table scan by using LIKE rather than another qualifier (equals, greater, less than.) Again, if you have NOT indexed the field AND set the QBE to something other than always, then a scan will take place anyway. Indexing and using the index is the key to stopping table scans.
James McKenzie
L-3 GSI
________________________________
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: Tuesday, October 31, 2006 11:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: QUESTION: MENU - NOT LIKE
**
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)" <arslist@ARSLIST.ORG>
10/31/2006 05:59 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: QUESTION: MENU - NOT LIKE
**
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:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ] On Behalf Of Guillermo Alfredo Torres Barron
Sent: Monday, October 30, 2006 5:45 PM
To: arslist@ARSLIST.ORG
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___
