optimizer Hints in forms

[lecorr]

Please help!!!

I have a very slow query generated by forms, but when I use and optimizer hint in SQL*Plus, it is much faster. This is good. But when I put this optimizer in the field optimizer hint of the block property called optimizer hint, forms does not put it in the query.

I use forms 6.0.5.0.2 with DB 8.1.7.

HELP!!!!

Thanks

Christian

 

[sem]

Do you enter the whole hint? I mean /* + FIRST_ROWS*/ or just FIRST_ROWS? The second is correct.

Regards, Dima

 

[lecorr]

I put the second.

With no effect...

 

[sem]

How do you know it doesn't put it in query? Did you look at v$sqltext?

Regards, Dima

 

[lecorr]

Yes I saw it via a tool called tora (similar to TOAD). It shows the query and the explain plan and other infos. I am sure the hint is not put in the query.

Regards.