What is indexed views?
plz explain with example?
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 |
how can you attach more than 20 ldf files in sql server
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Can Somebody tell me the difference between Clustered & Non- Clustered Index??
How many triggers you can have on a table?
How many .ndf files can we create in Sql server 2005?
What number aggregate functions are accessible there in sql?
What is blocking and how would you troubleshoot it?
What is raiseerror? What is raiseerror?
Explain the steps to create and execute a user-defined function in the sql server?
Will count(column) include columns with null values in its count?
How to insert stored procedure result into temporary table?
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)