Shehap, I read your article and it is very helpful. Now I have a new question: how can I improve a query that has expression like @variable = ''...
Thanks. Here is another question. One table is used in two different select queries with overlap fields. Should I create one index including...
Shehap, Thank you very much for your replies. Before running your queries to create indexes, I added "set statistics io on" at the beginning of...
SELECT distinct DISTRICT_DIM.DISTRICT_NUMBER, DISTRICT_DIM.DISTRICT_DESCRIPTION FROM ORGANIZATION_HIERARCHY_DIM INNER JOIN DISTRICT_DIM ON...
I have a stored procedure. I have added indices to all fields that in where clause, join, order by, and select. Then I ran the stored procedure...
Separate names with a comma.
