Day 16
Quiz
| 1: | What does it mean to streamline a SQL statement? |
| A1: | Streamlining a SQL statement is taking the path with the least resistance by carefully planning your statement and arranging the elements within your clauses properly. |
| 2: | Should tables and their corresponding indexes reside on the same disk? |
| A2: | Absolutely not. If possible, always store tables and indexes separately to avoid disk contention. |
| 3: | Why is the arrangement of conditions in a SQL statement important? |
| A3: | For more efficient data access (the path with the least resistance). |
| 4: | What happens during a full-table scan? |
| A4: | A table is read row by row instead of using an index that points to specific rows. |
| 5: | How can you avoid a full-table scan? |
| A5: | A full-table scan can be avoided ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
