i created a database with table in SQL 2008 Express Edition. Then I created few index key from one table.
e.g. Index A of Table A is on Field1, Index B of Table A is on Field 2, Index C of Table A is on Field 3
how can i use different index key on different select statment?
e.g. select Field1 from table where Field1 = ???? (this case, I want to use Index A)
select Field2 from table where Field2 = ???? (this case, I want to use Index B)
how can i control to use index key based on different select statement?
since i have big volumn of rows in table, the index can improve the performance for searching and updating.
pls help, thx
View Complete Post