# SQL Optimization Examples
This repo contains examples of **SQL query optimization techniques** for better performance.
---
## π Contents
- Indexing strategies
- JOIN optimization
- Aggregation and grouping optimization
- Execution plan analysis
---
## π‘ Example
### β Slow query
```sql
SELECT * FROM Orders WHERE YEAR(OrderDate) = 2023;
---
β
Optimized query
CREATE INDEX IX_Orders_OrderDate ON Orders(OrderDate);
SELECT * FROM Orders WHERE OrderDate BETWEEN '2023-01-01' AND '2023-12-31';
---
π« About Me
Backend Developer with strong skills in C#, .NET, SQL optimization, and performance tuning.-
Notifications
You must be signed in to change notification settings - Fork 0
milannedeljkovic-webdev/sql-optimization-
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Β | Β | |||
Repository files navigation
About
primeri optimizacije
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published