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 tcode to create indexes?
What is the transaction code to display the payroll results
Diff b/w LUW and Lock Mechanism?
What is a modification assistant?
How to maintain lists?
What is sap abap tables?
CAN ANY BODY TELL ME IN A COMPANY HOW BAPI WORK WILL GOES? WHO WILL TELL WHICH BAPI WILL SET FOR THE PRESENT REQUIRENT?
how ro trigger a top of page in alv report?
where u can u set the pages in script (don't say first page, remaining pages i want)?
How do you delete duplicate records from internal table?
What are the objects of the abap dictionary or what types of objects can be created in the abap dictionary? : abap data dictionary
stock transfer from one plant to another plant ? i want the total description.
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)