Re: 4s query want to run faster

On 21-Feb-08, at 6:16 PM, Scott Marlowe wrote:

> On Thu, Feb 21, 2008 at 4:59 PM, Mark Kirkwood  
>  wrote:
>> The other parameter you might want to look at is  
>> effective_cache_size -
>> increasing it will encourage index use. On a machine with 16GB the
>> default is probably too small (there are various recommendations  
>> about
>> how to set this ISTR either Scott M or Greg Smith had a page  
>> somewhere
>> that covered this quite well - guys?).
>>
The default is always too small in my experience.

What are the rest of the configuration values ?

Dave