Index corrupted

We need to know, how to reorganize or reindex on sql-ce?

With SQL CE 2.0, the only mechanism to re-calculate index stats and repair corruption is to call the Compact method on the SqlCeEngine object. If you want to assess the degree of selectivity of your current index, you can open your SQL CE database in Pocket Query Analyzer and run sp_show_statistics_steps 'table', 'index'

Check the SQL CE Books Online for an example of using the Compact operation.

-Darren