Service Contracts Extract Query is Taking Long Time to Return Results (Doc ID 2091854.1)

Last updated on DECEMBER 22, 2015

Applies to:

Oracle Service Contracts - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

Customer has a custom program which will extract the service contracts data from okc_k_headers_all_b , okc_k_lines_b and okc_k_items based on last_update_date of these tables. As there are no indexes on these standard columns, query is taking very long time. We need this data only daily basis to push to custom tables followed by data warehouse. Could you please advise creating indexes on these tables for date who columns?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms