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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / surendra
we can create number of indexes we want but these are useful to us to speed up the retreive the records
such as these columns are simultaneously used in where clause
when we create more indexes that are not necessary to us at that time the performance is definitely decreased.
so, create indexes depends upon the usage.
Is This Answer Correct ? | 4 Yes | 3 No |
What are the attributes of the cursor?
What is integrity and what is constraint??Explain with example
Explain coalesce function?
How oracle handles dead locks?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is a deadlock in SQL? How can you prevent it?
Differentiate between post-database commit and post-form commit?
How to create id with auto_increment on oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Compare and contrast between sql and sql server and explain its various functions?
Explain the use of tables option in exp command.
What is an oracle database?