how many indexes can be created for a table?

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

Question Posted / neerajalaxmi

7 Answers
14806 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how many indexes can be created for a table?..

Answer / sharath

1 Primary Index and 21 secondary Index totally 22 Index we can create in ECC6.00.

Is This Answer Correct ?

1 Yes

0 No

how many indexes can be created for a table?..

Answer / gopi paruchuri

16 Primary indexes and 9 secondary indexes

Is This Answer Correct ?

1 Yes

0 No

how many indexes can be created for a table?..

Answer / damodar reddy

For any table we can create 1 primary index and maximum of
15 secondary indexes.

Is This Answer Correct ?

3 Yes

5 No

how many indexes can be created for a table?..

Answer / niranj

You should not create more than five indexes for any one
table because:

Whenever you change table fields that occur in the index,
the index itself is also updated. The amount of data
increases. The optimizer has too many chances to make
mistakes by using the 'wrong' index.

If you are using more than one index for a database table,
ensure that they do not overlap.

Is This Answer Correct ?

3 Yes

7 No

how many indexes can be created for a table?..

Answer / vadamalai a

Only 9 Indexes allowed

Is This Answer Correct ?

3 Yes

7 No

how many indexes can be created for a table?..

Answer / bala

1 index..

Is This Answer Correct ?

3 Yes

9 No

how many indexes can be created for a table?..

Answer / sukhbir

Max : 15 index.

Is This Answer Correct ?

1 Yes

8 No

Post New Answer