SQL Server CE Indexes

[Chris Stephens]

Hi folks,

Can anyone give me some pointers on how ssce uses indexes and the best way
to implement them. For example, should I create separate indexes for all
fields used in a "where" clause, or a single index with all the "where"
clause fields?

Chris

 

[franky]

For sure if you create a index for all of the "WHERE clause" you use it will
be fast for select... but not fantastic for all your Update, Insert,
delete.....

You how to use take a look on the book online at :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_indexes.asp

have fun!
__________________________
Franky
(e-mail address removed)

 

[Enrico Pavesi]

For best perfomance is better to open the table and make a seek if you are
not using a multitable select.

Enrico