Interested to Buy Any Domain ? << Click Here >> for more details...
What is indexed views?
plz explain with example?
- 2 Answers
- 4432 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan
A view with Clustred Index is known as Indexed view.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / raman
A view with unique Clustred Index is known as Indexed view and its also known as Materialize view
| Is This Answer Correct ? | 0 Yes | 0 No |
What types of integrity are enforced by a foreign-key constraint
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
What is data modeling and Reterminal integrity?
How to disable stored procedure sql server?
What is change data capture (cdc) feature?
What are the differences between UNION and JOINS?
3 Answers CarrizalSoft Technologies,
How to enable tcp/ip protocol on a sql server?
can foreign key take role of primary key?
5 Answers CarrizalSoft Technologies, TCS, Villa Marie,
How to change server name in sql server?
What do you understand by sql server agent?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
-
Oracle (3259) - 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)
