Hour 17. Improving Database Performance

Team-Fly

---

 

	Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
	Table of Contents
	Part V.  SQL Performance Tuning

---

Hour 17. Improving Database Performance

During this hour, you learn how to tune your SQL statement for maximum performance using some very simple methods .

The highlights of this hour include

• What SQL statement tuning is

• Database tuning versus SQL statement tuning

• Formatting your SQL statement

• Properly joining tables

• The most restrictive condition

• Full table scans

• Invoking the use of indexes

• Avoiding the use of OR and HAVING

• Avoiding large sort operations

---

Team-Fly

Top