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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: