Amit > But I will ask you how do you know that that you can > set only set some(but not all parameters) with opt_param? Everything begins with an observation. I tried to set one and it didn't work as expected. Later, during a discussion, a developer working for the query optimizer group confirmed me that through the hint not all parameters can be set. HTH Chris -- //www.freelists.org/webpage/oracle-l