Will between operator work faster than relational operators ?
Dear All,
I would like to know whether the between operator will work faster than >= and <= operator ?
For instance if the query has the condition like the one below which of these queries works faster ?
(A)Select * from empmast where doj between '01-sep-2002' and '31-dec-2002'
Or
(B)Select * from empmast where doj>='01-sep-2002' and doj<='31-dec-2002'
Can anyone guide me please ?
Regds,
Ramakrishnan L