Interested to Buy Any Domain ? << Click Here >> for more details...
What technical problem you will face if you create many secondary indexes.
- 2 Answers
- 7825 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / pratap
Secondary indexes should contain columns that you use frequently in a selection, and that are as highly selective as possible.
Only 9 Indexes allowed
from efficiency point of view only 5 can be created because
You should not create more than five indexes for any one
table because:
Whenever you change table fields that occur in the index,the index itself is also updated. The amount of data increases. The optimizer has too many chances to make mistakes by using the 'wrong' index.
If you are using more than one index for a database table,ensure that they do not overlap.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What will you code in start-of-selection & end-of-selection ?
In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary
In order to upload purchase order details, how you handle multiple values for a single field?
Explain the difference between get and get late?
How are the function code handles in flow logic?
Program lines for the radio button selection and unabling some input variables in section screen
What are the screen elements.
Can we create field without data element? If yes, how?
What is open sql?
How can we set the table spaces and extent sizes? : abap data dictionary
In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?
What are the attributes of the data in data dictionary? : abap data dictionary
What is modularization and its benefits?
What are the page windows? How many main windows will be there in a page window?
How do you write transaction programs in sap?
