The PROFILER tab will occur in the DATA/RESULTS pane after executing a SELECT query if the ‘Query Profiler’ feature is turned ON. If all options were selected in ‘Preferences’ the…
SQLyog lets you filter and sort data interactively from the GRID display of the program’s RESULT/TABLE DATA tab. The sort and filter criteria selected interactively from the GUI as explained…
Indexes in a database are double-sided: They are required for SELECT queries on large tables to be fast and efficient, but on the other side whenever data in a table…
The Schema Optimizer feature analyses what data are stored in the table and proposes schema changes that will optimize the table (column types and column lengths) to fit existing data.…
The Info tab shows information about all objects of currently selected database object in the Object Browser (Database, Table or other object). Also the Info tab will populate with data…
There is an option in Preferences to change the position of History tab to either the Upper pane or Lower pane. Reconnects and failures to reconnect will be written to…
It shows the information about the various query(s) executed (e.g. number of row(s) returned/ updated / modified etc.) All those data are as they are returned in the ‘status message’…
