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
- 7934 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 background process in Oracle?
How to recover a dropped table in oracle?
What is Data Dictionary Cache in Oracle?
How to connect to oracle using service name instead of sid?
How to invoke the data pump import utility?
Can we call procedure inside function in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is not equal to in oracle?
Can you assign multiple query result rows to a variable?
How to export data to a csv file?
What are the different pseudo commands? Explain in general?
Please explain oracle left join with an example?
What is control file used for?
What is the purpose of save points in oracle database?
How can Oracle users be audited?
