Interested to Buy Any Domain ? << Click Here >> for more details...
About Indexed Views? with example?
plz reply...
- 2 Answers
- 8340 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sruthi
Index created on view is called as indexed view or
materialised view.
To create index on a view we should create a view
with "schemabinding"
eg:
create view v1 with schemabinding as
select empno,ename from dbo.emp
---
while creating view with schema binding refer to table by
default owner
---
now create index on that view
--
create clustered index i1 on v1(empno)
--
now this is called as indexed view
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / manoj joshi
Creating index on views is not possible in Sybase.
| Is This Answer Correct ? | 6 Yes | 0 No |
What is normalization and its forms?
4 Answers Challenger Financial,
How can you list all the table constraints in a database?
What are the different types of backup avaible in SQL SErver
What is index, cluster index and nonclustered index?
How to delete database objects with "drop" statements in ms sql server?
How to sort query output in descending order in ms sql server?
How to delete an existing database user?
How will you optimize a stored procedure optimization?
What does it mean if @@cursor_row returns a negative number?
Explain about sql server login?
Scalability, Availability, Integration with internet, etc.)?
What is difference between order by and group by?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
