WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXE

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT
OD SECONDARY INDEXES?

Question Posted / sudhakar1207

7 Answers
17686 Views
Sony, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / sudhakar1207

SECONDARY INDEXES ARE USED FOR FAST RETRIEVAL OF DAT FROM THE DB TABLES.

WE CAN CREATE MAXIMUM OF 15 SECONDARY INDEXES.

Is This Answer Correct ?

22 Yes

3 No

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / paru

If primary index is not enought to speed up the data
retrieval, We can create secondary index.

Maximum Limit: 15
Advisable : 6 or 7.

Is This Answer Correct ?

18 Yes

0 No

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / sateesh

primary keys of a table are defined as primary index.
if it is not sufficient for improve the performance.
we will create secondary indexes.maximum 15 secondary indexes
possible

Is This Answer Correct ?

6 Yes

2 No

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / shankar

in sap abap two types of indexes are they supported
1) one is primary index it is automatically created when ever
user create table it contrains combination of primary key fields
2)secondary index can be created user it is combination
of some primary key fields and non primary key fields
there is no limit creation of secondary indexes
try it and make sure maximun less no of indexes are suggests
if more indexs user can not understand which index is used

Is This Answer Correct ?

2 Yes

1 No

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / sagi.nagamani

to increase the performance in getting data from data base
table i.e. to speed up the process.we can create
secondary indexes maximum 9.

Is This Answer Correct ?

3 Yes

3 No

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / g.shankar

sorry for the above ans 2ndry index is used to enhance the
performance of a select statement for a non-primary key...

Is This Answer Correct ?

1 Yes

2 No

WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?..

Answer / g.shankar

guys the question is about 2ndry index not about only index..
2ndry index is used to increase the performance for where
condition..and we can create a maximum of 16 2nry indexes..

Is This Answer Correct ?

2 Yes

4 No

Post New Answer