I don't think that is true? LIKE searches ignores indexes to the best of my knowledge if you use the wildcard anywhere to the left of the string you are comparing..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, April 07, 2008 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Bar Nothing of course, but it would prevent searches like 'Field' != "value" which if memory serves, ignores indexes. Assuming it can be done anyway. Michael A. McManus, SSgt, USAF -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Monday, April 07, 2008 1:45 PM To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Bar ** If you did that, then what would stop them from keying values in the fields themselves? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, April 07, 2008 13:42 To: arslist@ARSLIST.ORG Subject: Advanced Search Bar ** Dear listers, It's been some time since anyone on my project has been to the performance and tuning class and we're having some performance issues at peak times. I'm sure we're getting killed in multiple areas (QBE settings, Indexing, etc.) but one of the questions I was asked is about the Advanced Search Bar. I did a quick scan of the docset and didn't see an answer. Is there any way to prevent users from using the Advanced bar? I see a menu for "Search Bar" in the form action fields, but it's not checked on any of our forms. Thanks much, Michael A. McManus, SSgt, USAF No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.8/1362 - Release Date: 4/6/2008 11:12 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
