Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     WF and Oracle partitioning
Go
New
Search
Notify
Tools
Reply
  
WF and Oracle partitioning
 Login/Join
 
Silver Member
posted
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
 
Posts: 36 | Location: Bologna Italy | Registered: March 11, 2004Reply With QuoteReport This Post
<Grzegorz>
posted
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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     WF and Oracle partitioning

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.