×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
The View is a runtime object, so no real performance improvement, in my opinion.
Steve Needles
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Friday, May 04, 2018 10:08 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Better SQL performance than SUBSTRING
I've never done this for performance reasons and this is just a WAG, but what about creating a view that includes a new field that is a substring per your example? It would still be a substring, but would performance be better since it's defined in a view?
- Dan
On Fri, May 4, 2018 at 10:16 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:
I know that a LIKE performs better than a SUBSTRING in a SQL WHERE
clause. Is there a better option than a SUBSTRING for checking
specific positions in a column?
Given MY_TABLE with MY_COLUMN defined as char(12) and this query:
Select *
From MY_TABLE
Where substring(MY_COLUMN, 5, 6) = '123456';
Is there an alternative to SUBSTRING that will perform better?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
CONFIDENTIAL: The information contained in this email communication is confidential information intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by return email and destroy all copies of this communication, including all attachments.
midrange.com
