Hi,

I am trying to create a index on a table which has as many as 37Million records. This is a child table and has the foreign key with the parent table.

Earlier in the day, I created the indexes on the column(which is also the foreign key) and the index creation went through in less than 45 minutes. At that time the FK constraint was disabled.

Now I have enabled the FK and am trying to create index on another column, It's taking a long time more the 3hours and still going on.

Is there any relation between FK constraint and Indexes.
Please clarify.

Badrinath