[Database | Optimization] Add Indexes to Database Tables

[AbreuHD]

The goal of this issue is to optimize database performance by adding appropriate indexes to key tables. Proper indexing will enhance query speed, reduce response times, and improve overall database efficiency, especially for frequently accessed data.

Tasks to be completed

• Identify database tables that require indexing based on query patterns and performance metrics.
• Analyze existing queries to determine the best columns to index (e.g., primary keys, foreign keys, frequently filtered columns).
• Implement the necessary indexes while considering:
  • Single-column indexes for high-search columns.
  • Composite indexes for queries filtering multiple columns.
  • Unique indexes to enforce data integrity where applicable.
• Test database performance before and after adding indexes to measure improvements.
• Update the database schema documentation to reflect the new indexes.

Acceptance criteria

• Appropriate indexes are added to improve query performance without significant overhead.
• Query execution times are reduced based on benchmarking.
• No negative impact on database insert/update operations.
• All changes are documented and reviewed for best practices compliance.

Additional notes

Consider using tools like SQL Server Execution Plan, PostgreSQL EXPLAIN ANALYZE, or MySQL EXPLAIN to analyze query performance before and after indexing.