10 Replies Latest reply on Jun 3, 2016 5:31 AM by parrotola

    Hint Explaine Plan - Query federation with rest service

    parrotola Novice

      Hi everybody,

      I have this query:

      SELECT *

           FROM      geo_table,

                            table( exec "modelOpenStreetMap"."getStreeMap"(geo_table.dindirizzo || ',' || geo_table.dcomune,'1','json','1')) t

              limit 10

      I created a Rest Service Source that it does a lookup with openstreeMap with my address table.

      I would like to use a Hint that make a join row by row. in this way the query plane execute all lookup call before  the limit clause.

       

      Best regards.

       

      Francesco