For 9th Tip BETWEEN operator is also going to impact performance.In place of BETWEEN we can use

trunc(time_id)>='12/01/2001' and trunc(time_id)<='12/30/2001'