Create indexing

[Aleksandergreg]

User Story

As a database developer,
I want to create and implement appropriate indexes on my database,
so that I can significantly improve query performance and reduce data retrieval times.

---

Acceptance Criteria

• Indexes are created on relevant columns or fields based on common query patterns.
• Performance improvements are measured and documented, comparing query execution times before and after index creation.
• Postman monitors (if applicable) demonstrate a noticeable reduction in response times for affected API endpoints.
• The impact of indexes on write operations (insert, update, delete) is considered and documented.
• The chosen indexing strategy is documented, including the rationale behind index selection.

---

Tasks

• Analyze common query patterns and identify columns/fields suitable for indexing.
• Create indexes on the identified columns/fields using appropriate database commands.
• Measure and record query execution times before and after index creation.
• Update Postman monitors (if applicable) to track API response times for affected endpoints.
• Document the indexing strategy and performance results.
• Present the performance improvements and indexing strategy during the exam presentation.

---

INVEST Principle

I: Independent, N: Negotiable, V: Valuable, E: Estimable, S: Small, T: Testable

• Independent: This task can be completed independently, given access to the database.
• Negotiable: The specific indexes can be discussed and adjusted based on performance results and team feedback.
• Valuable: This directly improves application performance and user experience.
• Estimable: The effort can be estimated based on the database size and complexity.
• Small: This can be completed within a sprint or iteration.
• Testable: Performance improvements can be measured and verified using query execution times and API response times.

---

Additional Context / Notes (Optional)

• Consider using database-specific tools or commands to analyze query performance and identify potential indexing opportunities.
• Pay attention to the trade-off between read performance and write performance when creating indexes.
• If using a NoSQL database, explore different indexing strategies such as secondary indexes, compound indexes, or geospatial indexes.
• When presenting, include specific examples of queries and their performance improvements.
• If postman is used, include screen shots of the postman monitor before and after the index implementation.