Actions
Activity #3769
openModule #3123: Application, Database Optimization, Tuning
Sub module #3580: Address issues, feedback Trial Run 1
Record time for data query and steps for Query optimization
Start date:
06/19/2025
Due date:
% Done:
0%
Estimated time:
Planned Due Date:
06/20/2025
Description
Check the DB function for CTD-temp plot and modify to optimize query.
Record data fetch time before and after optimization
- Identify fields to add index based on search columns used in function
- avoid select *
- Use Explain Plan to check whether indexes are being used effectively in function
Discuss output.
No data to display
Actions