ORS Database Indexing Considerations for Offline and Online Updates
Last updated on JANUARY 11, 2012
Applies to:Oracle Real-Time Scheduler - Version: 10.4.9
Information in this document applies to any platform.
1. When is a suitable time to apply the index changes to the ORS database so that they do not impact the ORS application/website?
2. What impact would be caused while the tables are locked?
3. What is the impact of modifying the following tables to allow live indexing?: stop_shift_archive, drop index shift_date, drop depot_stop_shift_archive, drop stop_job.
4. Will the product provide the ability to do live indexing in the future?
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