create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 4260 Views
- I also Faced
- E-Mail Answers
Answer Posted / yousaf khan
First the Control will check if there clustred index exist
if there then it will create a nonclustred Index a on
Employee(dno), other case there is condition diffine like
clustred or nonclustred so it create Defualt type.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we get count of the number of records in a table?
explain different types of joins? : Sql server database administration
What are the disadvantages of primary key and foreign key in SQL?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
How to throw custom exception in Stored Procedure?
What do you mean by data integrity?
Distinguish between nested subquery and correlated subquery?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Explain different types of self contained sub query?
What is built-in/administrator?
What is the purpose of update statistics and scope_identity() function?
What is the order by used for?
How to create a local temporary stored procedure?
How you can change the database name in SQL SERVER?
How to rebuild the master database?
