Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7956 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 the exact use of Collections?
What is connection pool in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
What is the usage of merge statement?
How to sort output in descending order in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is the difference between translate and replace?
Explain the types of exception?
What happens if recursive calls get out of control?
Name the various constraints used in oracle?
What is logical backup in oracle?
What is oracle datasource?
What is a view and how is it different from a table?
What is a proxy object?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
