Chapter 15. SQL Server 2005 Compact Edition Performance Tuning


This chapter highlights the tips that you can use to increase the performance of the SQL Server Compact Edition database. You will learn the internals of query optimization and how Query Optimizer uses indexes, statistics, and joins. We will also discuss the execution plan that tells you what is going on inside when the database engine is executing the query. These internals will provide you with the necessary clues to make the right trade-offs and help you to determine the appropriate choices for your database ...

Get Microsoft SQL Server 2005, Compact 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.