I will short my question. (SQL-Server 2008)
Is it a good idea , when crating a new table, to create an index for each column?
Why i'm saying this?
Today I was creating a database, and my boss was behind me, and he said:
"Oh, it's good to create an index, for every column" (and then he showed me the graphic way to do this).
I'm studying indexes now and I'm not sure if this is a good idea, since every index will be updated everytime time there will be an insert\update on the table.
Some advices?