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
- 6960 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 null value in oracle?
How do I connect to oracle?
How to sort the query output in oracle?
How index is implemented in oracle database?
What is connection pooling in oracle?
What is an anonymous block?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is the difference between a user and a schema in oracle?
What is the dynamic sql in oracle?
What is Undo Management Advisor in Oracle?
How to insert a record into a table?
How to retrieve data from an cursor to a record?
Give the various rollback segment states.
Difference between varchar and varchar2 data types?
What are the different windows events activated at runtime ?
