What are the basic requirements of an index number?
Answer:
A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns. The disk space required to store the index is typically less than the storage of the table (since indexes usually contains only the key-fields according to which the table is to be arranged, and excludes all the other details in the table). In a relational database an index is a copy of part of a table.so indexes saves a fair amount of time to search the records .
It should be an integer or a long value that is >= 0.
The answers post by the user, for information only, FunQA.com does not guarantee the right.
More Questions and Answers: