Viewing 5 posts - 16 through 20 (of 20 total)
Dear All,
Do you think Clustered columnstored index is suit for my case? I read Internet which said it suit for DW but I saw there is calculation included....
August 24, 2018 at 8:10 pm
Dear ScottPletcher,
Noted. Thanks.
According to your suggestion, what should I put in junction table? Is it table_A.uid & Table_B.uID? If I create materialize view, what would be...
August 23, 2018 at 9:42 pm
Dear sgmumson,
Please find below for my ans for your question.
SELECT
August 23, 2018 at 3:14 am
Dear ScottPletcher,
Yes. We need every match from Table_B to Table_A. We need to list every role whenever there is no value for Ag_CD or Dept or .... As...
August 23, 2018 at 2:34 am
Dear Jonathan,
Yes. It is actually inner join already since we have join in where clause.
My indexes are as follows.
Table_A=>
Create Clustered Index on
August 20, 2018 at 8:15 pm
Viewing 5 posts - 16 through 20 (of 20 total)