Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

vinski-dev/sql-queries-optimization

Open more actions menu

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
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

No packages published
Morty Proxy This is a proxified and sanitized view of the page, visit original site.