I have a view that I've built for the Projects Accounting module that joins many related tables to get the Project Cost transaction detail. The view is quite slow when run wide open. One of the tables, PA_COST_DISTRIBUTION_LINES_ALL, is set to a full table scan. Is there a way I can put a hint in the view code to force the use of an index?

    Requires Free Membership to View

    Login

Yes, you can put an index hint in your SQL. For example, let's say that you want to use index Idx_Emp_id to access your Employee table. Here is the hint that could accomplish this. 
 /*+ Index(Employee Idx_Emp_id) */

This was first published in May 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top