Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • SQL Selectivity

    @ishan.bhatnagar
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 281
    Comment on it

    Selectivity

    Selectivity is used for the definition of the number of unique values in the table.

    It shows how many unique values are there in the table.

    Selectivity=Cardinality/number of record *100%

    If the selectivity is high than only the database index is used.

    There are many unique values that means the selectivity of the table is high.

    It means there is need of index.

    Selectivity then basically is used as query optimizer to get that if index applied to the table can be efficient or not

    or reading the full table would do the work.

    My Sql selectivity database data
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: