Re: Full table scan performance differences - why?
Date: Thu, 18 Sep 2008 11:17:40 -0700 (PDT)
You could have posted more statistics after taking a sql trace. But i could think of one instance where the CPU used could have been more.
In 10G if you compare a date datatype (VER_DAT in this case) to a TIMESTAMP variable (i dont know what datatype ret_pkg.get_date returns), then oracle converts the data type to timestamp (i have seen even indexes not being used on DATE datatype for this reason) for the comparision, which could be costly if comparing many rows.
srivenu Received on Thu Sep 18 2008 - 13:17:40 CDT