Other Topics SQL Performance

Document performance analysis for each complex query that you have produced:

Propose indexes that could improve the performance of the query. Document performance analysis using EXPLAIN PLAN to execute the query before the creation of the indexes, and after the creation of the indexes. Document whether the indexes were truly used in the execution plan Conclusion about the performance gains Security measures

Document the security measures you have introduced in your application related to database access (prevention of SQL injection, prevention of un-authorized access to data, …) Document the security measures you have introduced in your database related to database access (prevention of SQL injection in dynamic queries, prevention of un-authorized access to data, …) Other developments

…