2 Replies Latest reply: Oct 14, 2012 5:21 AM by Deepak Vadithala RSS

    Which will give efficient performance? Use of Database view or Load & link in QVW



      I need to use data from 5 tables in Oracle Database. Assume that I do have access to create views in the database.

      Which will give efficient performance (Speed in load and refresh)?


      a. I create a single view making all necessary links of 5 tables. I load data straight from the view.

      b. I load data from 5 tables individually and map/link in QVW (In case of automatic links not possible I need to map in QVW)