sql server - create view with indexes -


I would like to create a scene, which will present the same property as a table 

  View Agent_view as Agent View   
 I need to know that I need to make  indexed in Agent_View similar to  Agent_table   Also.  
 Do I need to declare  Agent_View  as schemabound to create an index? Is there any alternative way to make indexes without declaring as schemound?   
 
 You can index the view with  SELECT *  because you are indexed Without having  titration   
 not just a macro that is spread in the external query. Therefore table indexes will be used anyway. The scene does not exist from a schema perspective.  
 Finally, IMHO is probably the most useless use of a possible view, it adds  zero value .

Comments

Post a Comment