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
- 6956 Views
- I also Faced
- E-Mail Answers
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
What is an oracle database?
Difference between the “verify” and “feedback” command?
What is the sid in oracle?
How to recover a dropped table in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is a system tablespace and when it is created?
Difference between cartesian join and cross join?
What is oracle latest version?
Can objects of the same schema reside in different tablespace?
What are the system predefined user roles?
How to insert multiple rows with one insert statement in oracle?
How to use "startup" command to start default instance?
What is a package in oracle?
How to define an anonymous procedure with variables?
How does Oracle guarantee data integrity of data changes?
