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
- 7412 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
Hi Can any one tell me what are the API's used in requisition import.
How to assign values to data fields in record variables?
Give the various exception types.
What are the different pseudo commands? Explain in general?
Is it possible to split the print reviewer into more than one region ?
Is primary key indexed by default in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Explain the difference between sql and oracle?
What do you mean by merge in oracle?
What is an oracle tablespace?
What happens if variable names collide with table/column names?
What is system global area (sga) in oracle?
How to convert csv to table in oracle?
What is the database name in oracle?
What is an oracle user account?
