Interested to Buy Any Domain ? << Click Here >> for more details...
create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 4760 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 equi join with example?
What is data modification?
Can you always create a cache of a report?
What is it’s similarity with sql server?
When do you think a developer should use sql server-based cursors?
Explain “@@rowcount” and “@@error” in sql server?
Explain what is it unwise to create wide clustered index keys?
What are the tools available in market as an alternative to sql server reporting services?
What is indexing and its types?
How to list all user defined functions in the current database?
What is subquery explain with example?
How to delete an existing database user?
What is xml datatype?
Does full backup break log chain?
what are database files and filegroups? : Sql server database administration
