nonclustered index syntax
create index (index-name) on (table-name) (column-name)
where (predicate logic)
include (columns)
with
fillfactor=(n)
pad_index=on/off

@datascienceie