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
- 7842 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
Explain the use of control file?
How to resolve the ORA-39133 error in Oracle?
What is the usage of analyze command in oracle?
Explain an exception?
How to create a new view in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the difference between 10g OEM and 11g OEM?
How can you use check constraints for self referential integrity?
What is oracle database 10g express edition?
How to convert csv to table in oracle?
How to do paging with oracle?
How to connect to the server with user account: sys?
How to Truncate Table in Oracle
What are the different types of trigger and explain its various uses and functions?
How do we display rows from the table without duplicates?
