|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = ' ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ' AND `innodb_index_stats`.`table_name` = 'Кількість дзвінків кожного абонента' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
GEN_CLUST_INDEX |
2019-12-02 18:43:04 |
n_diff_pfx01 |
24 |
1 |
DB_ROW_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = ' ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ' AND `innodb_index_stats`.`table_name` = 'Кількість дзвінків кожного абонента' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
GEN_CLUST_INDEX |
2019-12-02 18:43:04 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = ' ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ' AND `innodb_index_stats`.`table_name` = 'Кількість дзвінків кожного абонента' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'size'
|
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
GEN_CLUST_INDEX |
2019-12-02 18:43:04 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = ' ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ' AND `innodb_index_stats`.`table_name` = 'Тарифна сітка' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
GEN_CLUST_INDEX |
2019-12-02 18:25:36 |
n_diff_pfx01 |
2 |
1 |
DB_ROW_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = ' ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ' AND `innodb_index_stats`.`table_name` = 'Тарифна сітка' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
GEN_CLUST_INDEX |
2019-12-02 18:25:36 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = ' ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ' AND `innodb_index_stats`.`table_name` = 'Тарифна сітка' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'size'
|
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
GEN_CLUST_INDEX |
2019-12-02 18:25:36 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'CustomerID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
AutoRepairShop |
Appointment |
CustomerID |
2024-09-23 11:53:54 |
n_diff_pfx01 |
0 |
1 |
CustomerID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'CustomerID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
AutoRepairShop |
Appointment |
CustomerID |
2024-09-23 11:53:54 |
n_diff_pfx02 |
0 |
1 |
CustomerID,AppointmentID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'CustomerID' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
AutoRepairShop |
Appointment |
CustomerID |
2024-09-23 11:53:54 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'CustomerID' AND `innodb_index_stats`.`stat_name` = 'size'
|
AutoRepairShop |
Appointment |
CustomerID |
2024-09-23 11:53:54 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
AutoRepairShop |
Appointment |
PRIMARY |
2024-09-23 11:53:54 |
n_diff_pfx01 |
0 |
1 |
AppointmentID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
AutoRepairShop |
Appointment |
PRIMARY |
2024-09-23 11:53:54 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Appointment' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
AutoRepairShop |
Appointment |
PRIMARY |
2024-09-23 11:53:54 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
AutoRepairShop |
Billing |
PRIMARY |
2024-09-23 11:53:55 |
n_diff_pfx01 |
0 |
1 |
BillingID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
AutoRepairShop |
Billing |
PRIMARY |
2024-09-23 11:53:55 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
AutoRepairShop |
Billing |
PRIMARY |
2024-09-23 11:53:55 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'ServiceRecordID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
AutoRepairShop |
Billing |
ServiceRecordID |
2024-09-23 11:53:55 |
n_diff_pfx01 |
0 |
1 |
ServiceRecordID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'ServiceRecordID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
AutoRepairShop |
Billing |
ServiceRecordID |
2024-09-23 11:53:55 |
n_diff_pfx02 |
0 |
1 |
ServiceRecordID,BillingID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'ServiceRecordID' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
AutoRepairShop |
Billing |
ServiceRecordID |
2024-09-23 11:53:55 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Billing' AND `innodb_index_stats`.`index_name` = 'ServiceRecordID' AND `innodb_index_stats`.`stat_name` = 'size'
|
AutoRepairShop |
Billing |
ServiceRecordID |
2024-09-23 11:53:55 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Customer' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
AutoRepairShop |
Customer |
PRIMARY |
2024-09-23 11:53:53 |
n_diff_pfx01 |
0 |
1 |
CustomerID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Customer' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
AutoRepairShop |
Customer |
PRIMARY |
2024-09-23 11:53:53 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Customer' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
AutoRepairShop |
Customer |
PRIMARY |
2024-09-23 11:53:53 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Part' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
AutoRepairShop |
Part |
PRIMARY |
2024-09-23 11:53:54 |
n_diff_pfx01 |
0 |
1 |
PartID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'AutoRepairShop' AND `innodb_index_stats`.`table_name` = 'Part' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
AutoRepairShop |
Part |
PRIMARY |
2024-09-23 11:53:54 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |