Focal Point
WF and Oracle partitioning

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4381087331

July 07, 2004, 11:03 AM
Busca
WF and Oracle partitioning
Does anyone know if WebFocus reporting server works on Oracle partitioning tables and relative limits or problems ?

That is if I can use

JOIN ......
and
TABLE FILE .....

instead of SQL PASSTHROUGH

Thanks in advance
Paolo
July 07, 2004, 12:36 PM
<Grzegorz>
Paolo,

Oracle documentation states that partitioning is transparent for the client application, so it should not have any impact on WebFOCUS queries (instead of the fact, that queries should run faster on the very large table).
If you encounter any problem after partitioning the table it is an Oracle problem, not WebFOCUS.
But it is still good to see what SQL statement are generated by WebFOCUS (the forum post) to decide if hand-optimized PASSTHROUGH is necessary.

Hope this helps
Grzegorz