On Sun, Jul 26, 2009 at 1:02 AM, Greg Caulton wrote:
> Hello,
>
> It seems to me that the following query should be a lot faster. This runs
> in 17 seconds (regardless how many times I run it)
>
> select ac.* from application_controls_view ac, refs r where
> ac.custom_controller_ref_id = r.ref_i
Hello,
It seems to me that the following query should be a lot faster. This runs
in 17 seconds (regardless how many times I run it)
select ac.* from application_controls_view ac, refs r where
ac.custom_controller_ref_id = r.ref_id and r.ref_key like '%XYZ%';
if I do not use the view the query r
On Fri, Jul 24, 2009 at 1:13 AM, Marc Cousin wrote:
>> It really has very little impact. It only affects index scans, and
>> even then only if effective_cache_size is less than the size of the
>> table.
>>
>> Essentially, when this kicks in, it models the effect that if you are
>> index scanning a
