02-21-2007 7:02 AM
Hi,
I got these question in interview Plz answer them
1. Maximum number of primary keys u can use for a table?
2. Maximum number of indexes u can create?
3. Maximum number of secondary indexes?
4. Maximum number fields in a table?
5. Maximum length of primary key field?
Plz answer these questions
regards,
kumar
02-21-2007 7:06 AM
HI,
1) There can be only one primary key for a table.
2) You can create upto 9 but should not be more than 5 for performance reaons.
3) You can create upto 9 secondary indexes.
Regards,
Sesh
02-21-2007 7:06 AM
HI,
1) There can be only one primary key for a table.
2) You can create upto 9 but should not be more than 5 for performance reaons.
3) You can create upto 9 secondary indexes.
Regards,
Sesh
02-21-2007 7:08 AM
Hi sesh,
Thanx for ur response
What about Primary indexes, table fileds, Primary key field lengths?
regards,
kumar
02-21-2007 7:14 AM
Hi,
Since we can have only one primary key the primary index is nothing but an index automatically created by database interface using the primary key the number of primary indexes is also ONE.
I am not sure about the limit on number of fields in the table and the Length of the primary key.
Regards,
Sesh
02-27-2007 2:49 AM
02-21-2007 7:21 AM
Hi Phani,
I think a table can have atmost 16 primary keys.
For further info on primary keys and foreign keys read this link.
http://cma.zdnet.com/book/abap/ch04/ch04.htm
Regards,
Priyanka.
02-21-2007 7:33 AM
Hi,
1) 16
2) Maximum number of indexes are 9
3) Maximum number of indexes are 9
4) you can create the fields upto the lenght 256, so create the fields as you want but the total lenght of these fields should not exceed 256
5) 16
02-21-2007 6:53 PM
02-21-2007 8:54 PM
Hi,
1) You can have only one primary key but u can include as many field as u want.
2) 16 - > u shud avoid creating so many indexes
3) Maximum number of indexes are 16
4) you can create the fields upto the lenght 256, so create the fields as you want but the total lenght of these fields should not exceed 256
02-26-2007 1:03 AM
>>1. Maximum number of primary keys u can use for a table?
16
>>2. Maximum number of indexes u can create?
>>3. Maximum number of secondary indexes?
Only 16 Primary Index and n number of secondary indexes.
>>4. Maximum number fields in a table?
249
>>5. Maximum length of primary key field?
255
Cheers,
Hakim
Mark all useful answers..Close the thread once your question has been answered.
02-27-2007 3:23 PM
hi phani
i have answers for some of your question:
- maximum no. of primary keys in a table = 16.
- maximum no. of indexes that cam be created = 1.
- maximum no of fields in a table < 250.
- maximum length of primary key field = 255.
and for maximum number of secondary indexes i also dont know. so please let me know whenever u get the right answer.
02-27-2007 5:31 PM
i think ashwani mittal and hakim , had the right answers. im sure abt it.