Database Tuning (MOSC)

MOSC Banner

Undertand the syntaxe difference

edited Nov 1, 2013 9:43AM in Database Tuning (MOSC) 6 commentsAnswered
 I want to know what is the difference in executing the queryselect * from tb_test where date_inc > to_date('31/10/2013','dd/mm/yyyy') that is not using the index created, and the query
select * from tb_test where date_inc between to_date('31/10/2013','dd/mm/yyyy') and trunc(sysdate+1) that is using the index and both queries returns the same records?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center