Before Creating Indexed views What you will Check the rules
Hi Experts,
<1> Before Creating Indexed views What you will Check the rules
not all these
1. creating view in Schema Binding option,
2. Count_big() in Select statement and
3. then after Creating An Index to view
What are those...................................!
<2> In Which Memory CTE is Created/stored/Declared in SQL SERVER not in TEMP DB, Where
Exactly !
Thanks & Regards
D.vijayabhaskar
ph-7676020160