Postgresql Indexing Strategies vs SQL Window Functions Cheatsheet

Compare these two topics side by side to decide which to study first — or tackle both!

📚

Postgresql Indexing Strategies

Databases

120

Cards

~60m

Study time

Advanced

Difficulty

Sample questions

▸What is an index in PostgreSQL?
▸What is a B-tree index in PostgreSQL?
▸Which index access method is the default in PostgreSQL?
▸What index types does PostgreSQL ship with for general use?
▸What is the main trade-off of any index?

Study Postgresql Indexing Strategies →

📚

SQL Window Functions Cheatsheet

Databases

223

Cards

~112m

Study time

Advanced

Difficulty

Sample questions

▸Running total of <i>amount</i> by <i>user_id</i> ordered by <i>ts</i>?
▸Difference between ROW_NUMBER, RANK, DENSE_RANK?
▸Top N rows per group?
▸Previous row's value in same partition?
▸Next row's value?

Study SQL Window Functions Cheatsheet →

🤔 Which should you study first?

Both topics are in the Databases category, so they complement each other well. We suggest starting with the smaller deck to build momentum:

Postgresql Indexing Strategies

120 cards · ~60 min · Advanced

⭐ Quicker to complete

SQL Window Functions Cheatsheet

223 cards · ~112 min · Advanced

📊 More comparisons

VS Postgresql Performance Tuning vs SQL Window Functions Cheatsheet