通过根据执行计划添加索引来调整查询。

取决于版本的您正在使用的SQL Compact可以使用SQL Management Studio（v4.0之前版本）或Visual Studio 2010 Sp1 Transact SQL编辑器。

以下MS Technet链接可以帮助您掌握性能调优; 查询性能调优（SQL Server Compact） [ ^ ]



亲切的问候

Look at tuning the Query through adding indexes based on the execution plan.
Depending on what version of SQL Compact you are using you can use SQL Management Studio (pre v4.0) or Visual Studio 2010 Sp1 Transact SQL Editor.
The following MS Technet link should help you with getting a handle on performance tuning; Query Performance Tuning (SQL Server Compact)[^]

Kind Regards