How do you choose between SQL and NoSQL for a new project?

SQL indexes, transactions and performance · Experienced

Model answer

Decide from data shape and access patterns. Choose SQL for relational data, constraints, joins, reporting and transactions. Choose a document or key-value store for flexible schemas or very simple, high-volume access patterns. Many systems combine both.

Learn this topic

Indexes and Faster Queries: EXPLAIN for Beginners in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is an index and why use it?
• What is a transaction?
• What does ACID mean?
• What is the difference between a clustered and a non-clustered index?
• What is a composite index and why does column order matter?
• How do you check how a query runs?