Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SHOW INDEX FROM UserActions;
- +-------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
- | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
- +-------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
- | UserActions | 0 | PRIMARY | 1 | actionId | A | 252163120 | NULL | NULL | | BTREE | | |
- | UserActions | 1 | downloaded | 1 | userId | A | 627915 | NULL | NULL | YES | BTREE | | |
- | UserActions | 1 | downloaded | 2 | actionType | A | 793157 | NULL | NULL | YES | BTREE | | |
- | UserActions | 1 | downloaded | 3 | mediaId | A | 149933056 | NULL | NULL | | BTREE | | |
- | UserActions | 1 | downloadedVersions | 1 | userId | A | 850228 | NULL | NULL | YES | BTREE | | |
- | UserActions | 1 | downloadedVersions | 2 | mediaVersionId | A | 126656472 | NULL | NULL | YES | BTREE | | |
- | UserActions | 1 | downloadedVersions | 3 | actionType | A | 162126896 | NULL | NULL | YES | BTREE | | |
- | UserActions | 1 | wasChecked | 1 | wasChecked | A | 1 | NULL | NULL | YES | BTREE | | |
- | UserActions | 1 | wasChecked | 2 | actionType | A | 657 | NULL | NULL | YES | BTREE | | |
- +-------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement