Timeline for search for text across multiple tables
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 26, 2018 at 8:27 | comment | added | Paul | Why are you having to RTRIM your name fields? Make sure there are no trailing spaces on the data being input instead, surely? Function calls like this hamstring SQL as it can no longer use indexes on those fields but instead has to scan the entire table, applying the function to every value. | |
| Feb 21, 2018 at 15:26 | answer | added | paparazzo | timeline score: 1 | |
| Feb 21, 2018 at 14:49 | comment | added | paparazzo | You can find out if it is a volume thing just by select count(*) | |
| Feb 21, 2018 at 14:48 | answer | added | Wes H | timeline score: 2 | |
| Feb 21, 2018 at 14:43 | comment | added | paparazzo | An what are the apx table sizes | |
| Feb 21, 2018 at 14:37 | history | edited | 200_success | CC BY-SA 3.0 |
deleted 1 character in body; edited tags; edited title
|
| Feb 21, 2018 at 14:35 | history | edited | BCdotWEB | CC BY-SA 3.0 |
deleted 30 characters in body; edited title
|
| Feb 21, 2018 at 14:09 | answer | added | Malachi | timeline score: 1 | |
| Feb 21, 2018 at 13:59 | comment | added | chicks |
Welcome to Code Review. What indexes are there on those tables? What does the output of explain look like for your query?
|
|
| Feb 21, 2018 at 13:34 | review | First posts | |||
| Feb 21, 2018 at 13:59 | |||||
| Feb 21, 2018 at 13:29 | history | asked | Pauly N. | CC BY-SA 3.0 |