O'Reilly logo

Microsoft SQL Server 2005, Compact Edition by Trent Swanson, Prashant Dhingra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. SQL Server 2005 Compact Edition Performance Tuning

IN THIS CHAPTER

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required