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
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
How to start an oracle instance?
What is data type in oracle?
What is Library Cache in Oracle?
How to retrieve data from an explicit cursor?
What is key preserved table?
What is meant by joins? List out the types of joins.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to manage transaction isolation level?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What are the varoius components of physical database structure of oracle database?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is a static data dictionary in oracle?
How to invoke the original export import utilities?
How many types of tables are there in oracle?