What is selectivity of an Index

  1. Ratio of number of distinct values in column/columns to the total number of rows in the table

  2. Ratio of total number of rows in the table to the number of distinct values in column/columns

  3. Ratio of distinct values in the table to the total number of rows in the table

  4. Total number of rows


Correct Option: A

Find more quizzes: