Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 5 of 5 total |
Sensitive vs insensitive |
Tue, Oct 23 2018 4:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Dunno how possible it is but can we have the reason for Insensitive when Sensitive has been requested as part of the execution plan
eg with Ian Branch's post it was a mismatch in the ORDER BY to index definitions or it might be a JOIN etc Roy Lambert |
Tue, Oct 23 2018 1:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Dunno how possible it is but can we have the reason for Insensitive when Sensitive has been requested as part of the execution plan eg with Ian Branch's post it was a mismatch in the ORDER BY to index definitions or it might be a JOIN etc >> So, you're asking for EDB to analyze all of the indexes and see if one closely-matched ? Okay, in that case, define "closely"... I'll take a look. I might be able to do something for the case-insensitive flag/collation matching. Tim Young Elevate Software www.elevatesoft.com |
Wed, Oct 24 2018 2:47 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Dunno how possible it is but can we have the reason for Insensitive when Sensitive has been requested as part of the execution plan > >eg with Ian Branch's post it was a mismatch in the ORDER BY to index definitions or it might be a JOIN etc >> > >So, you're asking for EDB to analyze all of the indexes and see if one closely-matched ? Okay, in that case, define "closely"... > >I'll take a look. I might be able to do something for the case-insensitive flag/collation matching. That's a lot more than I was asking for - I was thinking more along the lines of "Problem with ORDER BY caused production of insensitive result set" or "Use of JOIN requires switch to insensitive result set" Something has to trigger the switch and its that I was hoping for. If you can provide the detail then that's a lot more useful. Roy |
Tue, Oct 30 2018 1:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< That's a lot more than I was asking for - I was thinking more along the lines of "Problem with ORDER BY caused production of insensitive result set" or "Use of JOIN requires switch to insensitive result set" >> Yep, no problem, that's an easy one. I've got a new 2.29 coming out pretty soon - I'm finishing up the MacOS port right now, and then it will get released. Tim Young Elevate Software www.elevatesoft.com |
Wed, Oct 31 2018 4:08 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Thanks Roy Lambert |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |