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.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms