Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 290 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 115 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Need index on LAST_UDPATE_DATE
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
Accenture Technologies
Description (Required):
We are using the BI and OIC route to get the data out of Saas and have a framework to do the sync of data from Saas to Pas and this relies on the last_update_date column to find the incremental rows to be synced.
Since the data is growing in Saas this is getting slower and slower and timing out in the OIC layer as it has 270 seconds threshold, So the INDEX on this WHO column (LAST_UPDATE_DATE) would speed up the data retrieval and prevent the timeouts.
Use Case and Business Need (Required):
Data Sync from Saas to Paas for the extensions and reports
Enhancement Request / Service Request:
3-29762789045
3-29762789021
3-29762789605
3-29762789478
3-29327424441
3-29762789472
Comments
-
This is across all the modules
0