Get flash to fully experience Pearltrees
How do you know when a table is fragmented? Poor query performance over time. More disk activity.
SQL Query Optimization FAQ Part 1 (The SQL Plan) 1) Introduction and Goal 2) What is a SQL execution Plan? 3) Can we understand step by step how SQL Query plan is created and executed? 4) Ok, so where do I start from? 5) What is a Table Scan (Operator number 1)? 6) Can performance increase by adding a unique key for table scans?