Post reply

Clustered Index in SQLCE?

  • February 11, 2009 at 7:02 pm

    #199805

    Does SQLCE support clustered indexes? I can't seem to create one either through a script or the Management Studio. I'm not even sure how critical it is, but I have a third party sync system that it might make a difference to.

  • February 11, 2009 at 9:16 pm

    #942592

    from what i read, you cannot create a clustered index on CE other thant eh PK of the table'http://www.developmentnow.com/g/97_2005_2_0_0_384968/Clustered-Indexes.htm

    also, CE can only use one index at any time, but i dunno what impact that really ahs.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 11, 2009 at 9:22 pm

    #942595

    I hadn't looked at it that much, but one index per table. Makes you think CE is more of a small local data store for lookups than a real database.

    Pick your indexes wisely.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply