| describe revision_userindex; |
6 years ago |
| show tables; |
6 years ago |
| describe revision_userindex;
|
6 years ago |
| describe revision;
|
6 years ago |
| describe revision_userindex;
|
6 years ago |
| describe revision;
|
6 years ago |
| use enwiki_p;
select count(*) from revision where rev_user = 130326;
|
6 years ago |
| use enwiki_p;
select count(*) from revision where rev_user = 130326;
|
6 years ago |
| select count(*) from revision where rev_user = 130326;
|
6 years ago |
| explain select count(*) from revision where rev_user = 33956805;
|
6 years ago |
| explain select count(*) from revision use index(user_timestamp) where... |
6 years ago |
| -- select count(*) from revision use index(user_timestamp) where rev_user =... |
6 years ago |
| -- select count(*) from revision use index(user_timestamp) where rev_user =... |
6 years ago |
| -- select count(*) from revision use index(user_timestamp) where rev_user =... |
6 years ago |
| -- select count(*) from revision use index(user_timestamp) where rev_user =... |
6 years ago |
| select count(*) from revision use index(user_timestamp) where rev_user = 33956805;
|
6 years ago |
| select count(*) from revision use index(user_timestamp) where rev_user = 33956805;
|
6 years ago |
| select count(*) from revision where rev_user = 33956805 using index user_timestamp;
|
6 years ago |
| select count(*) from revision where rev_user = 33956805;
|
6 years ago |
| -- select * from revision where rev_user = 33956805;
describe revision; |
6 years ago |
| -- select * from revision where rev_user = 33956805;
SHOW INDEX IN revision; |
6 years ago |
| -- select * from revision where rev_user = 33956805;
SHOW INDEX IN revision; |
6 years ago |
| select * from revision where rev_user = 33956805; |
6 years ago |
| select * from revision where rev_user_id = 33956805; |
6 years ago |
