*Hi Kathy Morris,*
Your second part of the question-->*
Sometimes when I use LIKE %Mary Smith I find the name faster than if I
type = "Mary Smith" - never understood why.
*
*
Answer-->*
A search on a character field with a QBE match type of "Anywhere"
performs a full table scan of the database,
reading every record in a form and ignoring any indexes for the field.
Searches on fields where the QBE match type is "Leading" or "Equal" are
typically *faster* than searches on fields
where the match type is Anywhere, especially if the field is indexed, as
described in Defining indexes <forms6.html#wp256590>.
Some relational operators and wildcards work during a query-by-example
regardless of the QBE Match setting.
This means that users can specify an exact match in a field with a QBE
Match setting of "Anywhere" by using the equal sign (=) relational
operator.
Users can also use the percent sign (%) wildcard at the beginning of the
search string (|%abcd|) to override a QBE Match setting of "Leading" or
"Equal".
However, using the % wildcard anywhere else in a string (|abcd%|) does
not override the "Equal" setting.
Overriding the "Leading" or "Equal" QBE Match settings overrides the
performance benefits of using those settings.
Hope this helps...
Regards,
*Sandeep
Vyom Labs Pvt. Ltd.
An ISO 20000 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*
Kathy Morris wrote:
Hello all,
I ran this qualification:
'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi" AND
'Status*' <= 3
Result: status values that such as Closed and Cancelled appeared that
have a value of 5 and 6??
When I modified the qualification:
('Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi") AND
'Status*' <= 3
Result: the values that were less than or equal to 3 appeared correctly.
What logic is this based on?
Sometimes when I use LIKE %Mary Smith I find the name faster than if I
type = "Mary Smith" - never understood why.
------------------------------------------------------------------------
Wondering what's for Dinner Tonight? Get new twists on family
favorites at AOL Food
<http://food.aol.com/dinner-tonight?NCID=aolfod00030000000001>.
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
