Before Creating Indexed views What you will Check the rules

Feb 25 2015 3:37 AM
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