True wisdom is in knowing you know nothing - Socrates
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Try executing the dates at last and null validation ast first .. this way it might improve performance based on number of null records.
True wisdom is in knowing you know nothing - Socrates
Matt Kohanek wrote:Thanks for all the tips everyone - turns out not much can be done as you say - I just have hundreds of thousands of records to go through so there is not much to be done
No more Blub for me, thank you, Vicar.
chris webster wrote:
Using "IS NULL" or "IS NOT NULL" disables the use of an index on a column, even if you had an index on it.
Martin Vajsar wrote:Though your advice is very valuable, I'd have a small clarification:
chris webster wrote:
Using "IS NULL" or "IS NOT NULL" disables the use of an index on a column, even if you had an index on it.
Definitely not, at least in Oracle....
No more Blub for me, thank you, Vicar.
Consider Paul's rocket mass heater. |