Add database indexes to the ab-test entity

[RUKAYAT-CODER]

Overview

src/email-marketing/entities/ab-test.entity.ts declares no @Index. Columns that are used for lookups, filtering, sorting, or as foreign keys are therefore unindexed, forcing sequential scans as the table grows. Add appropriate indexes (and a migration that creates them) so the common query paths for this entity stay performant.

Specifications

Features:

• Frequently-queried columns and foreign keys on this entity are indexed.
• The indexes are created by a reviewable migration rather than only synchronize.

Tasks:

• Review the query paths that hit ab-test and identify the columns used in WHERE / ORDER BY / JOIN / foreign-key lookups.
• Add @Index decorators (single-column or composite as appropriate) to src/email-marketing/entities/ab-test.entity.ts.
• Add a migration that creates the same indexes so existing databases are updated.

Impacted Files:

• src/email-marketing/entities/ab-test.entity.ts
• src/migrations/-add-ab-test-indexes.ts

Acceptance Criteria

• The entity carries indexes covering its common lookup/foreign-key columns.
• A migration creates the indexes and runs cleanly on an existing database.
• No duplicate/redundant indexes are introduced.

[TracyRepo]

@TracyRepo has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hi maintainer, please consider assigning this to me. i'm a professional backend developer with experience across nestjs, typescript, databases, and api systems, and i can complete this on time.

i understand this requires reviewing the actual "ab-test" query paths before choosing indexes, then keeping the entity decorators and migration in sync. i'll add only the indexes that support common where/order/join paths, avoid redundancy, and verify the migration runs cleanly on an existing database.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @TracyRepo to this issue.

[devgbmuyiwa]

@devgbmuyiwa has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I can work on this issue
Kindly assign this to me.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @devgbmuyiwa to this issue.

[Hagar001-lab]

@Hagar001-lab has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I would love to work on this issues

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Hagar001-lab to this issue.

[Sagethepeak]

@Sagethepeak has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hello i would like to work on this issue, i can do this.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Sagethepeak to this issue.

[339mon]

@339mon has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello I’m interested in contributing.
Please consider assigning this issue to me thank you so much.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @339mon to this issue.

[chainsmt]

@chainsmt has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello, can I work on this issue?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @chainsmt to this issue.

[drips-wave]

Congratulations, @339mon! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on August 31, 2026.

🧑‍💻 @339mon: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊