Timeline for How do I optimize query where searching for 'is not null' on either of two linked tables
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Oct 25, 2017 at 4:08 | history | edited | Paul White♦ | CC BY-SA 3.0 |
deleted 60 characters in body; edited tags
|
| Jul 26, 2017 at 6:31 | answer | added | KumarHarsh | timeline score: 1 | |
| Jul 24, 2017 at 9:06 | comment | added | ypercubeᵀᴹ |
Do you know that without parenetheses, your query is parsed and executed as WHERE ( b.my_column_x IS NOT NULL ) OR ( c.my_column_y IS NOT NULL AND b.start_date > ... AND b.end_date < ...) ?
|
|
| Jul 24, 2017 at 9:01 | history | edited | John K. N. | CC BY-SA 3.0 |
formatted code
|
| Jul 24, 2017 at 3:48 | history | edited | Chris Halcrow | CC BY-SA 3.0 |
corrected mistake in code sample
|
| Jul 24, 2017 at 3:01 | review | Close votes | |||
| Jul 24, 2017 at 9:01 | |||||
| Jul 24, 2017 at 2:42 | comment | added | Erik Reasonable Rates Darling | Possible duplicate of What are different ways to replace ISNULL() in a WHERE clause that uses only literal values? | |
| Jul 24, 2017 at 2:21 | history | asked | Chris Halcrow | CC BY-SA 3.0 |