Re: how to Change parameter at statement level

chao_ping wrote:
> Hi, seems we have a mis-understand between you and me.
> I don't think alter session at this instance can change the parameter
> at remote instance, this is why I am posting this question.
>
> To Morgan,
> The actual problem is more complicated. The actual query is like:
> select a.id, b.name, b.address from site_notes_at_admindb a, site_user b
> where a.last_modify_date > sysdate and a.last_modify_date < sysdate -1
> and a.id=b.id;
>
> There is an index on site_notes_at_admindb (id, last_modify_date), as
> oracle version is 8.1.7, skip scan is not avaliable. and I don't want
> to build another index (last_modify_date, id). So I will have to do a
> index fast full scan on admindb.
>
> Given the best plan I can get, I want to tune the index_ffs on remote
> admindb.
> Does anyone have a valid solution about this?
> Thanks

Still confusion here. You can not "tune" an index. Your choices here are quite Boolean.

An index that your query will use either exists or does not exist. That is your only choice other than making sure that appropriate statistics or hints are in play.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)