CREATE NONCLUSTERED INDEX [IX_SurfaceField_surfaceFieldName]
    ON [dbo].[pal_SurfaceField]([surfaceFieldName] ASC)
    INCLUDE([recId], [surfaceId], [surfaceFieldTypeId]);


CREATE NONCLUSTERED INDEX [IX_SurfaceField_surfaceId]
    ON [dbo].[pal_SurfaceField]([surfaceId] ASC)
    INCLUDE([recId], [surfaceFieldName], [surfaceFieldTypeId]);