Answer Posted / Prabhakar Awasthi
Important Index Characteristics include: 1) Unique: The indexed column should be unique or almost unique to reduce the number of records that need to be searched. 2) Narrow: The indexed column(s) should be as short as possible to minimize the storage space required for the index. 3) Frequently Used: The indexed column(s) should be frequently used in WHERE, ORDER BY, or JOIN clauses to improve query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category