Forum Stats

  • 3,874,252 Users
  • 2,266,710 Discussions
  • 7,911,785 Comments

Discussions

Discoverer - Views vs. Folders

3004
3004 Member Posts: 204,171 Green Ribbon
We have been told via a training class that the creation of views for use in Discoverer folders is not as efficient as just creating folders which read against the tables directly and then are linked. Has anyone proved this theory ? We currently create the views and then build the folders based on them. We feel that the direct method suggested by the teacher will cause a maintenance headache due to all of the linking that will need to go on. The WHERE's of the views we have are somewhat complex. Anyone encounter anything relevant to this ?
Thanks !!
Jim E.

Comments

  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    Your observation regarding maintenance is very important. I cannot exactly quantify the performance difference of the two methods (and in many cases it should not be much if any), but if maintenance is a bigger issue than a small performance tweak, then do whatever is better for maintenance. You don't want to spend 90% of your effort to get 10% performance improvement.

    Hope this helps,
    Oracle Discoverer Team http://technet.oracle.com

    <BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by James Ernst ([email protected]):
    We have been told via a training class that the creation of views for use in Discoverer folders is not as efficient as just creating folders which read against the tables directly and then are linked. Has anyone proved this theory ? We currently create the views and then build the folders based on them. We feel that the direct method suggested by the teacher will cause a maintenance headache due to all of the linking that will need to go on. The WHERE's of the views we have are somewhat complex. Anyone encounter anything relevant to this ?
    Thanks !!
    Jim E.
    <HR></BLOCKQUOTE>

    null
This discussion has been closed.