OK, I need this to sound again. I read articles online and I still have not found the final answer.
In SQL Server 2008, I have a "main" table containing about 50 thousand records and many read operations that are equally used in all queries. This data is updated once a month and read hundreds of times per second.
Data has a clustered index in the fields because it is often accessed. Let's say that a clustered index:
CLUSTERED INDEX
Field1 int
Field2 int
Field3 int
Field4 int
Field5 int
Now there isn’t much data anymore, so it would be wise to just add an extra pair of columns to the “Included Columns”, but SQL Server does not allow columns to be included in the Clustered Index.
, , , - " ". , , , , ?
()
Field1 int
Field2 int
Field3 int
Field4 int
Field5 int
Field6 varchar(96)
Field7 varchar(96)
, ?
, NO ( , )? , : " , ... ".
, ( , )? varchar ( ), , , , , .
, , , ?