Interested to Buy Any Domain ? << Click Here >> for more details...
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 many non clustered indexes there can be on table ?
What is a matrix in ssrs?
When should you use an instead of trigger?
What is sleeping status in sql server?
What is a partition key?
How to start and end transact-sql statements?
Is it possible to replicate data from sql server to oracle? : sql server replication
Explain subquery and state its properties?
What is difference between cte and view?
How to add an address record into adventureworkslt?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain the properties of subqueries in sql server?
How to use copy and concatenate commands in SQL?
What is shared lock?
What is difference between primary key and foreign key?
