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
- 8055 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
How to upsert (update or insert into a table)?
State all possible different index configurations a table can possibly have?
What is using clause and give example?
Calculate difference between 2 date / times in oracle sql?
How to create a table index?
What happens to the indexes if a table is recovered?
Is a rollback possible to any savepoint?
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 are the limitations oracle database 10g xe?
How to convert a date to char in oracle? Give one example.
How to connect ms access to oracle servers?
Explain the use of show option in imp command.
What are the differences between blob and clob in oracle?
Explain a synonym?
What to do if the startbd.bat failed to start the xe instance?
