What is an index?
By default system will create the primary index or User can
create,if user How?
And also Secondary indexes by User or by defaultly system?
Answers were Sorted based on User's Feedback
Answer / jenny
Indexes are a sorted copy of the table that exist in the
database which helps in faster retrival of data from the
database.
Primary Index : User cannot create a primary index, the
system creates a primary index by default based on the
primary keys of the table.
Secondary Index : The secondary indexes are created by the
user.we can create a maximum of upto 15 secondary indexes
for a table.
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / bandivenkateswarlu
Index is used to retrive the fast access the data from the
database by using the indexes. This is the efficient
mechanizam to retrive the data differnt databases.
indexes are two types of given below.
1.primary index.
2. secondary index.
1.primary index.: is used to access the only one record from
the database. That means that should be unique. It is also
called one to one relation ship.
2.secondary index: is used to access the data only more than
one record data base. This is called the secondary index.
The secondary index is used to relation ship is the
one-to-many relationships.
| Is This Answer Correct ? | 5 Yes | 8 No |
what is the difference between standard and sorted internal tables? (in performance wise)
to find an enhancement we will go to smod and check with the given package. but how can we know that a particular funx exit is used for particular enhancement( for eg: mm06e005 for mm22n screen exit.) will it be given by SD people or we have to find it?
explain the role of CTUPARAMS structure in call transaction
3 Answers Accenture, Atos Origin, IBM,
How do you document ABAP programs? Do you use program documentation menu option?
in real time with the help of scripts what we can do?
how will u write a report for performance point of view ?
What is the difference between call transaction method and the session method? : abap bdc
what are the two methods of modifying sap standard tables? : abap data dictionary
which select statement is used in script?
Difference between select option and ranges ?
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
What is Transactional based Application & Role based Application?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)