what is the maximum number of indexes i can create for a
table?
What happens if i create indexes for all the columns of a
table? Will it slow down the speed of retrieval
- 2 Answers
- 6961 Views
- I also Faced
- E-Mail Answers
Answer Posted / nawazish sultan
In sql server 2005 we create 250 indexes (1 clustered + 249
non clustered) where as in sql server 2008 it 999.
It is not a best practice to create indexes on all the
columns.Create index on whichever it is necessary becoz it
wont affect too much on DRL but it will obviously slowdown
the DML operation.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is recycle bin in Oracle?
What is a system tablespace and when it is created?
What is a subquery?
What is set verify off in oracle?
What is the maximum number of triggers that can be applied to a single table?
How to write a query with an inner join in oracle?
How to login to the server without an instance?
How to resolve name conflicts between variables and columns?
Why should I use oracle database?
What happens to the current transaction if the session is ended?
Can we create database in oracle using command line ?
How to establish administrator authentication to the server?
What happens if you set the sga too low in oracle?
How to rename an index?
How to use "in" parameter properly?
