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
- 7822 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 are the different types of trigger and explain its various uses and functions?
Can a formula column referred to columns in higher group ?
How remove data files before opening a database?
What is concurrency in oracle?
How to start an oracle instance?
if you ctreate table identity
How to revoke create session privilege from a user in oracle?
How many types of tables are there in oracle?
How to retrieve the count of updated rows?
What are the differences between date and timestamp in oracle?
What to do if dba lost the system password?
What are dml statements in oracle?
What is oracle database client?
What is a trace file and how is it created in oracle?
How to compare dates in oracle sql?
