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
- 7953 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
Please explain joins in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is private procedure oracle?
What is the fastest query method to fetch data from the table?
What is an oracle database?
Explain index?
What is Undo Management Advisor in Oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is set operator oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are the oracle differences between nvl and coalesce
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain what are synonyms used for?
Which is better Oracle or MS SQL? Why?
What is the relationship among database, tablespace and data file?
