SQL Query very slow

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

SQL Query very slow

Larz60+
aetate et sapientia
Super Moderators

Posts: 11,883

Threads: 474

Joined: Sep 2016

Reputation: 452

May-19-2019, 03:47 PM

Quote:Maybe it's the like operator? Can you clean up your data so that you can use an equality instead?

Actually this query is the beginnings of an attempt to clean up the data.
I'm dealing with legacy information, and thought I might be able to clean it up in place, but might be better off dumping the data and cleaning up that instead.

Find

Messages In This Thread

SQL Query very slow - by Larz60+ - May-18-2019, 11:02 PM

RE: SQL Query very slow - by MvGulik - May-19-2019, 12:23 PM

RE: SQL Query very slow - by ichabod801 - May-19-2019, 02:07 PM

RE: SQL Query very slow - by Larz60+ - May-19-2019, 03:47 PM

RE: SQL Query very slow - by richalt2 - May-20-2019, 04:32 PM

RE: SQL Query very slow - by Larz60+ - May-20-2019, 05:11 PM

RE: SQL Query very slow - by MvGulik - May-21-2019, 06:50 AM

RE: SQL Query very slow - by nilamo - May-21-2019, 06:12 PM

RE: SQL Query very slow - by Larz60+ - May-21-2019, 10:34 PM

RE: SQL Query very slow - by Mark87 - Jun-23-2019, 11:43 AM

RE: SQL Query very slow - by Larz60+ - Jun-23-2019, 04:11 PM

Users browsing this thread: 1 Guest(s)

View a Printable Version

SQL Query very slow

User Panel Messages

Announcements