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
Answer Posted / 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 |
Post New Answer View All Answers
How to use group functions in the select clause using oracle?
What do you mean by merge in oracle?
How to divide query output into groups in oracle?
What is a database schema in oracle?
What are the ways tablespaces can be managed and how do they differ?
What is an index associated with a constraint?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to run create database statement?
How will you identify oracle database software release?
What is a procedure in oracle?
What is meant by raw datatype?
How to add a new column to an existing table with a default value?
What is the dynamic sql in oracle?
Why do we need oracle client?
How do I start tns listener?