I'm having problem with two tables at the time of insert. The tables were created as follows:

I have a table "Page" that has a relationship with another table "Content" so that the FK "Page" falls within the "Content"

By the time I insert a new content, there is already an index on the table "Page" I want to put in the "Content" realize why a table scan select "Page" the correct line. The problem is that it's time to take a `InsertOnSubmit` the content. it automatically is also creating a new index on the "Page".

Anyone have any ideas?