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
Some queries related to SQL
do you know how to configure db2 side of the application? : Sql server database administration
Explain “@@rowcount” and “@@error” in sql server?
What is difference between cte and view?
What functions can a view be used to performed?
What are the difference between primary keys and foreign keys?
if no size is defined while creating the database, what size will the database have? : Sql server administration
How you would rewrite the sql query to return the customerid sorted numerically?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Can a rule be bound to any column of any data type?
What is role playing dimension with two examples? : sql server analysis services, ssas
Which are the new data types introduced in sql server 2008?
How to generate create table script on an existing table in ms sql server?
Is sql server is free?
How can we delete a table in sql server?
