I have ParentTable with 14,000 rows with PK on ID char(7) which already has clustered index.
The next table (ChildTable with 1,500,000 rows) has FK on ID char(7).
Question 1: Do I need to index this FK? This FK is not unique.
There is another field I will searching called Field1 also not unique.
Question 2: Is the following lines of code correct to build these two indexes?
CREATE INDEX index_FK_ID_ChildTable ON ChildTable (ID);
CREATE INDEX index_Field1_ChildTable ON ChildTable (Field1);
Question 3:Once these indexes get build, are created automatically? How long it might take. Any other pitfalls are there I need to be aware of?