hint materialize seems to be ignored when I run query through dblink
Hi all,
I have view with subquery factoring and materialize hint. It works fine when I select from view being connected in the same database where view was created.
But hint materialize is ignored when I run query like this using dblink
select * from tmp_v1@somedblink
Example of view:
create or replace view tmp_v1
as
with a as (select /*+materialize*/ level lvl from dual connect by level<100000)
select count(1) cnt from a;
Databasees from both side of dblink have the same 10.2.0.4.0 version.
Is there any way to make Oracle obey the hint materialize in this situation?