Answer Posted / suresh babu
We can create more number of indexes for a table.It required
separate memory space for each and every index.It will be
fast when using the search condition.
But if we are going to do some DML operations such as
insert,update,delete the server performance should reduce.
| Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
How does clustered and non clustered index work?
Explain indexing and what are the advantages of it?
What is the most common trace flags used with sql server?
Explain use of expression builder.
Explain timestamp datatype?
What is the difference between sdf and mdf?
What is the security principal at the database level that represents your session?
Explain database normalization?
What is logshipping and its purpose?
whats new about truncate in sql server 2008?
What is etl - extraction, transformation, and loading?
Which tcp/ip port does the sql server run on? How can it be changed?
What is an identity?
How do I view a script in sql server?
How and why use sql server?
