Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain indexed view?

Answer Posted / anindya basu

An indexed view is a part of the database and is saved to the disc. Creating an index on a view turns the latter into a permanent database object since indexes are so. Consequently every time the view is invoked, it gets loaded from the disc and need not be recreated.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can an automatic recovery be initiated by a user? : Sql server administration

945


How self join is different from outer join?

1117


How do I get to sql server configuration manager?

1004


Comment,Datatypes are unlimited

2056


Can you pass expressions to stored procedure parameters?

1024


How many triggers you can have on a table?

992


What is sub-query in sql server?

1199


What is encryption key?

130


What is difference between join and natural join?

960


How to transfer an existing table from one schema to another schema in ms sql server?

977


Mention the different authentication modes in sql server.

1042


What is replace and stuff function in sql server?

1059


Define clusters?

1056


How to write a query with an inner join in ms sql server?

1041


Can we call future method from queueable?

1040