how many indexes can be created for a table?
Answers were Sorted based on User's Feedback
Answer / satish
we can create 16 indexes
1 primary index
15 secondary indexes
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / abc
we can create 16 indexes
1 primary index
15 secondary indexes
Is This Answer Correct ? | 11 Yes | 3 No |
Answer / guest
Maximum 15 indexs are created for table
By,
Sathish.
Bhelssia
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / pradeep upadhyay
one clustered and unlimited non-clustered indexes can be
created in a table.
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / shailendra
I have created 35 indexes in one table in sql server 2000.
Is This Answer Correct ? | 0 Yes | 7 No |
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
what is Cross Applications?
What is reject statement? please reply me breifly?
Structures can contain data only during the runtime of a program (t/f) : abap data dictionary
Does SAP handle multiple currencies? Multiple languages?
What are function modules?
What is a data class? : abap data dictionary
1/ how can u move a logo from presentation server to application server ? 2/ The logo uploaded using rstxldmc prog . where it is going to store ? 3/ The logo is got inverted then how u handle this situation ? 4/what r clients ? what r the client no available in a company ? 800 client for which application ? 5/if i will display data by writing statement on start-of- selection then what is need of end-of-selection in classical reporting ? 6/ can u use at-line-selection & user-comand at atime in same programe ?
What Methods are using in Perform tuning
What are logical databases?
I have one BADI Definition , which i have use it in multiple Implementation .Now i am calling the BADI , In which Sequence the BADI will be called ? Can i control the sequence of calling ?
2 Answers Nissan, Renault Nissan,
What is up-casting and down casting? with example