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

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