There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Table structure

Settings for the table structure (list of columns).

Table structure

Default transformations
Hide table structure actions Whether the table structure actions should be hidden.
Show column comments Whether column comments should be shown in table structure view
Default transformations for Hex Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	2
Default transformations for Substring Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 all …
Default transformations for Bool2Text Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	T F
Default transformations for External Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	0 local
Default transformations for Inline Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 100
Default transformations for TextImageLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.	100 50
Default transformations for TextLink Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.

tbl_wt0_tmp

#	Name	Type	Collation	Null	Default	Action
1	RECID	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
2	RTYPE	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
3	DOCNO	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
4	SEQNO	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
5	DIV	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
6	PRDCD	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
7	QTY	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
8	PRICE	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
9	GROSS	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
10	CTERM	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
11	DOCNO2	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
12	ISTYPE	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
13	INVNO	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
14	TOKO	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
15	DATE	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
16	DATE2	varchar(50)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
17	KETERANGAN	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
18	PTAG	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
19	CAT_COD	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
20	LOKASI	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
21	TGL1	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
22	TGL2	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
23	PPN	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
24	TOKO_1	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
25	DATE3	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
26	DOCNO3	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
27	SHOP	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
28	PRICE_IDM	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
29	PPNBM_IDM	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
30	PPNRP_IDM	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
31	LT	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
32	RAK	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
33	BAR	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
34	BKP	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
35	SUB_BKP	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
36	PLUMD	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
37	GROSS_JUAL	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
38	PRICE_JUAL	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
39	KODE_SUPPLIER	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
40	DISC05	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
41	RATE_PPN	int(11)		Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
42	JAM	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns
43	KD_TOKO	varchar(100)	latin1_swedish_ci	Yes	NULL	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values Add to central columns

Check all With selected:

Propose table structure

Track table

Move columns

Normalize

Add column(s)

Indexes

Action			Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
Edit	Rename	Drop	RTYPE	BTREE	No	No	RTYPE	127	A	Yes
Edit	Rename	Drop	idx_ref	BTREE	No	No	SHOP	127	A	Yes
							DOCNO2	127	A	Yes
							RTYPE	127	A	Yes
							DOCNO	127	A	Yes
Edit	Rename	Drop	idx_shop	BTREE	No	No	SHOP	127	A	Yes
Edit	Rename	Drop	idx_tgl	BTREE	No	No	TGL1	127	A	Yes
Edit	Rename	Drop	idx_ket	BTREE	No	No	KETERANGAN	127	A	Yes

Partitions

Partitioned by: LIST COLUMNS(`DATE`)

#	Partition	Expression	Data length	Index length	Action
1	wt_220801	`DATE` < 220801	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
2	wt_220802	`DATE` < 220802	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
3	wt_220803	`DATE` < 220803	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
4	wt_220804	`DATE` < 220804	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
5	wt_220805	`DATE` < 220805	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
6	wt_220806	`DATE` < 220806	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
7	wt_220807	`DATE` < 220807	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
8	wt_220808	`DATE` < 220808	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
9	wt_220809	`DATE` < 220809	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
10	wt_220810	`DATE` < 220810	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
11	wt_220811	`DATE` < 220811	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
12	wt_220812	`DATE` < 220812	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
13	wt_220813	`DATE` < 220813	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
14	wt_220814	`DATE` < 220814	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
15	wt_220815	`DATE` < 220815	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
16	wt_220816	`DATE` < 220816	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
17	wt_220817	`DATE` < 220817	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
18	wt_220818	`DATE` < 220818	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
19	wt_220819	`DATE` < 220819	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
20	wt_220820	`DATE` < 220820	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
21	wt_220821	`DATE` < 220821	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
22	wt_220822	`DATE` < 220822	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
23	wt_220823	`DATE` < 220823	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
24	wt_220824	`DATE` < 220824	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
25	wt_220825	`DATE` < 220825	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
26	wt_220826	`DATE` < 220826	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
27	wt_220827	`DATE` < 220827	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
28	wt_220828	`DATE` < 220828	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
29	wt_220829	`DATE` < 220829	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
30	wt_220830	`DATE` < 220830	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
31	wt_220831	`DATE` < 220831	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
32	wt_220901	`DATE` < 220901	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
33	wt_220902	`DATE` < 220902	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
34	wt_220903	`DATE` < 220903	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
35	wt_220904	`DATE` < 220904	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
36	wt_220905	`DATE` < 220905	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
37	wt_220906	`DATE` < 220906	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
38	wt_220907	`DATE` < 220907	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
39	wt_220908	`DATE` < 220908	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
40	wt_220909	`DATE` < 220909	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
41	wt_220910	`DATE` < 220910	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
42	wt_220911	`DATE` < 220911	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
43	wt_220912	`DATE` < 220912	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
44	wt_220913	`DATE` < 220913	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
45	wt_220914	`DATE` < 220914	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
46	wt_220915	`DATE` < 220915	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
47	wt_220916	`DATE` < 220916	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
48	wt_220917	`DATE` < 220917	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
49	wt_220918	`DATE` < 220918	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
50	wt_220919	`DATE` < 220919	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
51	wt_220920	`DATE` < 220920	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
52	wt_220921	`DATE` < 220921	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
53	wt_220922	`DATE` < 220922	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
54	wt_220923	`DATE` < 220923	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
55	wt_220924	`DATE` < 220924	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
56	wt_220925	`DATE` < 220925	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
57	wt_220926	`DATE` < 220926	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
58	wt_220927	`DATE` < 220927	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
59	wt_220928	`DATE` < 220928	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
60	wt_220929	`DATE` < 220929	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
61	wt_220930	`DATE` < 220930	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
62	wt_221001	`DATE` < 221001	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
63	wt_221002	`DATE` < 221002	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
64	wt_221003	`DATE` < 221003	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
65	wt_221004	`DATE` < 221004	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
66	wt_221005	`DATE` < 221005	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
67	wt_221006	`DATE` < 221006	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
68	wt_221007	`DATE` < 221007	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
69	wt_221008	`DATE` < 221008	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
70	wt_221009	`DATE` < 221009	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
71	wt_221010	`DATE` < 221010	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
72	wt_221011	`DATE` < 221011	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
73	wt_221012	`DATE` < 221012	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
74	wt_221013	`DATE` < 221013	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
75	wt_221014	`DATE` < 221014	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
76	wt_221015	`DATE` < 221015	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
77	wt_221016	`DATE` < 221016	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
78	wt_221017	`DATE` < 221017	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
79	wt_221018	`DATE` < 221018	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
80	wt_221019	`DATE` < 221019	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
81	wt_221020	`DATE` < 221020	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
82	wt_221021	`DATE` < 221021	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
83	wt_221022	`DATE` < 221022	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
84	wt_221023	`DATE` < 221023	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
85	wt_221024	`DATE` < 221024	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
86	wt_221025	`DATE` < 221025	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
87	wt_221026	`DATE` < 221026	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
88	wt_221027	`DATE` < 221027	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
89	wt_221028	`DATE` < 221028	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
90	wt_221029	`DATE` < 221029	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
91	wt_221030	`DATE` < 221030	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
92	wt_221031	`DATE` < 221031	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
93	wt_221101	`DATE` < 221101	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
94	wt_221102	`DATE` < 221102	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
95	wt_221103	`DATE` < 221103	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
96	wt_221104	`DATE` < 221104	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
97	wt_220728	`DATE` < 220728	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
98	wt_221105	`DATE` < 221105	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
99	wt_221100	`DATE` < 221100	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
100	wt_221106	`DATE` < 221106	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
101	wt_221107	`DATE` < 221107	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
102	wt_221108	`DATE` < 221108	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
103	wt_221109	`DATE` < 221109	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
104	wt_221110	`DATE` < 221110	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
105	wt_221111	`DATE` < 221111	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
106	wt_221112	`DATE` < 221112	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
107	wt_221113	`DATE` < 221113	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
108	wt_221114	`DATE` < 221114	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
109	wt_221115	`DATE` < 221115	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
110	wt_221116	`DATE` < 221116	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
111	wt_221117	`DATE` < 221117	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
112	wt_221118	`DATE` < 221118	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
113	wt_221119	`DATE` < 221119	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
114	wt_221120	`DATE` < 221120	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
115	wt_221121	`DATE` < 221121	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
116	wt_221122	`DATE` < 221122	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
117	wt_221123	`DATE` < 221123	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
118	wt_221124	`DATE` < 221124	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
119	wt_221125	`DATE` < 221125	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
120	wt_221126	`DATE` < 221126	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
121	wt_221127	`DATE` < 221127	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
122	wt_221128	`DATE` < 221128	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
123	wt_221129	`DATE` < 221129	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
124	wt_221000	`DATE` < 221000	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
125	wt_221130	`DATE` < 221130	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
126	wt_221200	`DATE` < 221200	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop
127	wt_221210	`DATE` < 221210	16.0 KiB	80.0 KiB	Analyze	Check	Optimize	Rebuild	Repair	Truncate	Drop

Information

Space usage
Optimize table
Data	2.0	MiB
Index	9.9	MiB
Overhead	0	B
Effective	11.9	MiB
Total	11.9	MiB

Row statistics
Format	dynamic
Options	partitioned
Collation	utf8mb4_general_ci
Next autoindex	0
Creation	May 22, 2024 at 09:22 AM
Last update	Nov 02, 2026 at 03:49 PM
Last check	Nov 02, 2026 at 03:49 PM