Hi there, Does anybody know how to

[sem]

Hi there,
Does anybody know how to push optimizer hint into a view? I need to force using index on one of the inner view tables. I know it's possible, but can not remember syntax.

create view v as select id, value from tab t;

select /*+ index(smth I dont know)*/ id, value from v where id = 0

Regards, Dima

 

[sem]

Resolved. For curious:
inner table may be referenced as view_name.table_name. This may be applied also for higer nesting levels.

Regards, Dima