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
- 7133 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 a data dictionary and how can it be created?
How can we create the complete backup of data in the oracle.
What is recycle bin in Oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
what is the difference between restoring and recovering?
What do you mean by cdb and pdb in oracle 12c?
What is max rowid in oracle?
What are privileges and grants?
How to turn on or off recycle bin for the session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is merge statement used for?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to convert characters to numbers in oracle?
Can you assign multiple query result rows to a variable?
