Hi,

Create another index as below:

Table: - #tmp_sp_abc

Columns: - , , [r_type] include [test]

Also, you can create an indexed view on [t_h_bg_pc_it] with only required columns. You need to consider...

Great!

Please keep us posted about your findings in Production!

Thanks..

Hi,

Consider the following scenario:

1. Application x has a few transaction tables as very huge tables say tables t1, t2, t3, etc.

2. Application is only in maintenance mode and no changes...