Re: Full table scan performance differences - why?

From: <srivenu_at_hotmail.com>
Date: Thu, 18 Sep 2008 11:17:40 -0700 (PDT)
Message-ID: <a54f6d44-3bc9-4969-9137-af93b81d1728@p10g2000prf.googlegroups.com>

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.

regards
srivenu Received on Thu Sep 18 2008 - 13:17:40 CDT

This message: [ Message body ]
Next message: srivenu_at_hotmail.com: "Re: load data"
Previous message: srivenu_at_hotmail.com: "Re: Problems that can ocuur while upgrading from 9i 1o 10g"
In reply to: steph: "Full table scan performance differences - why?"
Next in thread: fitzjarrell_at_cox.net: "Re: Full table scan performance differences - why?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message