Correct - one way to avoid those performance hits with Oracle is to utilize the BMC Remedy Full Text Search add-on. It includes the ability to do case insensitive searches among its other benefits.
FTS can, of course, be used with any database - so it could be used to provide case insensitive searches within SQL Server (or Sybase, or DB2, etc...) as well. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Chowdhury, Tauf Sent: Thursday, March 25, 2010 9:27 AM To: [email protected] Subject: Re: Case Sensitivity in Remedy ** FYI, It is recommended by DBA and BMC to not use the case insensitivity feature in Oracle. It's possible to take a 50% performance hit with it enabled. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nall, Roger Sent: Thursday, March 25, 2010 12:21 PM To: [email protected] Subject: Re: Case Sensitivity in Remedy ** I think Rick might be thinking of Oracle. SQL is by nature case insensitive where as Oracle is case sensitive. I believe there is a setting in Oracle at the time of install to make Oracle case insensitive. Of corse I am not a DBA and could very well not have a clue as to what I am talking about. HTH, Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 http://saintake.t-mobile.com/interfaces/default.aspx From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Thursday, March 25, 2010 11:16 AM To: [email protected] Subject: Re: Case Sensitivity in Remedy ** That is a database setting. Usually is is only configurable at install time. Rick ________________________________ From: Kathy Morris <[email protected]> Date: Thu, 25 Mar 2010 12:09:35 EDT To: <[email protected]> Subject: Case Sensitivity in Remedy Hi, Is there any way to configure Remedy 7.x to be case insensitive We are on a SQL database. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
