Interested to Buy Any Domain ? << Click Here >> for more details...
create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 4661 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
What is tcl in sql server?
Do you know clustered and non-clustered index?
Can you explain different types of locks in sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is a cube? : sql server analysis services, ssas
Can you edit the .rdl code associated with a linked report?
What are the steps you should follow to start sql server in single-user mode?
How do I find the sql server instance name?
Define cursor locking
How can I add Reporting Services reports to my application?
What is the difference between web edition and business edition?
what is the difference between Delete and Truncate command in SQL
What is log shipping?
What does it mean to invest in the index?
What is sql or structured query language?
