What is cardinality in MySQL?

1.	What is cardinality in MySQL?
Answer» In MySQL, the time PERIOD cardinality REFERS to the SPECIALTY of facts VALUES that can be put into columns. It is a type of property that influences the potential to search, cluster and kind data. Cardinality can be of TWO sorts which are as follows Low Cardinality − All values for a column have to be the same. High Cardinality − All values for a column ought to be unique.

Answer»

In MySQL, the time PERIOD cardinality REFERS to the SPECIALTY of facts VALUES that can be put into columns. It is a type of property that influences the potential to search, cluster and kind data.

Cardinality can be of TWO sorts which are as follows

Low Cardinality − All values for a column have to be the same.
High Cardinality − All values for a column ought to be unique.

Discussion

No Comment Found

Related InterviewSolutions

How do you create view in MySQL?
What is view in MySQL?
What is the difference between timestamp and datetime in MySQL?
How to convert a string to utf 8 in MySQL?
What is the degree of a table in MySQL?
How to upload a large file through phpmyadmin in MySQL?
What is temporary table in MySQL?
What is heap table in MySQL?
How do I count the number of records in a MySQL query?
How can I see all indexes on a table in MySQL Database?

What is cardinality in MySQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment