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
What is partition index in sql server?
What is the cartesian product of the table?
Explain what role entity and relationship play in an ER diagram.
What are the different authentication modes in sql server?
What are system databases into sql server (2005/2008) : sql server database administration
What is the difference between row_number and dense_rank?
How to delete all rows with truncate table statement in ms sql server?
How to download and install the scaled-down database adventureworkslt?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Explain what is lock escalation?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is a data source or ds? : sql server analysis services, ssas
What are the differences between stored procedure and the dynamic sql?
what is difference between NULL and ISNULL in SQL Server 2008?
How can you manage sql azure security?
