Skip to content

vinski-dev/sql-queries-optimization

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 

Repository files navigation

Task 1: Complex SQL Query Optimization

  1. Setup SQLite or PostgreSQL and load sample data using baseline_queries.sql.
  2. Run baseline query and note execution plan.
  3. Apply index from optimized_queries.sql and run optimized query.
  4. Compare execution plans and timings.
  5. See docs/performance_report.md for details.

Commands example for SQLite: sqlite3 test.db < baseline_queries.sql sqlite3 test.db < optimized_queries.sql

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors