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 |
in lsmw,where u write the code?
6 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What is the difference between open_form and close_form?
what is the table to find change pointer status?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
What is client in the sap system? : sap abap hr
What happens when you post goods issue after delivery?
what is search helps..How many types are there?
how can we create editor box in alv grid? give coding
2 Answers Deloitte, Unilogic Software,
Performance tuning techniques
can u create internal table dynamically ? how?
4 Answers Bristle Cone, Cap Gemini, HP, IBM, MetaMorph, Satyam, Wipro,
can u send the results from report to sap memory?
2 Answers Bristle Cone, Cap Gemini, HP, Satyam, TCS, Wipro,
What are spa/gpa parameters (sap memory)?
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)