when does the secondary index should be used what role it
play when we use secondary index in tables

Answer Posted / akshay rao

If we use secondary index then the data is read faster from the database table, but when we write data its slower, The main reason of using Secondary index is to have a faster access to the tables.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the exits created in M.M and S&D?

1611


what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2100


Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?

1607


can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.

3038


how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....

1575






What are the two ways for restricting the value range for a domain? : abap data dictionary

532


what is user specific parameter?

1673


How are the function code handles in flow logic?

610


could anyone tell me what r real time questions been asked in interviews?i am in urgent need..thanks in advance

1442


How can we use multiple transactions by using bdc_insert? : abap bdc

644


What are the kinds of foreign key fields?

535


Explain the properties of selection screen?

651


What is the difference between the function module and a normal abap/4 subroutine? : abap modularization

695


How memory management happens for internal tables and work areas in abap?

728


What is screen flow logic? What are the sections in it?

600