High Database

Add indexes for foreign keys and frequently queried columns

Rule Description

Index: foreign keys, WHERE columns, ORDER BY columns, JOINs. Use EXPLAIN ANALYZE to verify.

Included in Rulesets

PostgreSQL Standards
24 rules • 0 standards
View
MySQL Standards
24 rules • 0 standards
View
MongoDB Best Practices
24 rules • 1 standard
View
Redis Guidelines
24 rules • 0 standards
View
SQLite Standards
24 rules • 0 standards
View
Code Review Standards
214 rules • 0 standards
View

Add This Rule

Sign in to add this rule to your workspace

Sign in with GitHub

Details

Severity
High
Category
Database
Used in
6 rulesets