Interested to Buy Any Domain ? << Click Here >> for more details...
create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 4863 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 do I schedule a sql server profiler trace?
What are click through reports?
What is a group function explain with an example?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to find the source of a table in sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are the two authentication modes in sql server?
What are sparse columns?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Do you know the cursor types?
How to generate create function script on an existing function?
how can you attach more than 20 ldf files in sql server
What is difference between standardization and normalization?
What is blocking?
What is the query and subquery?
