Friday, May 26, 2006
Tuesday, May 02, 2006
SQL index tip
This where clause can be made more simple and avoid unnecessary formatting by Oracle if you use the default Oracle format for the date test. Sometimes function calls will cause Oracle to disregard the index.
This:
Can be coded like this:
This:
update rad.dcd10dm
...
where dep > to_date('03/20/2006', 'MM/DD/YYYY');
Can be coded like this:
update rad.dcd10dm
...
where dep > '20-mar-06';
Subscribe to:
Posts (Atom)