Comments appear when the mouse pointer is moved over a table name. If
one of these parameters is set to TRUE, the corresponding item (database names for
DB and table names for TB) will be shown as the tooltip instead of the names. This
time, the mouse-over shows the true name for the item. This is convenient when the
real table names are not meaningful.
There is another possibility for $cfg['ShowTooltipAliasTB']: the 'nested' value.
Here is what happens if we use this feature:
The true table name is displayed in the left panel.
The table comment (for example project__) is interpreted as the project
name and is displayed as such. (See the Nested Display of Tables Within a
Database section in Chapter 3).
Table Order
When we Browse a table or execute a statement such as SELECT * from book,
without specifying a sort order, MySQL uses the order in which the rows are
physically stored. This table order can be changed with the Alter table order by
dialog. We can choose any field, and the table will be reordered once on this field.
We choose author_id in the example, and after we click Go, the table gets sorted on
this field.
Reordering is convenient if we know that we will be retrieving rows in this order
most of the time. Moreover, if later we use an ORDER BY clause and the table is
already physically sorted on this field, the performance should be higher.
Pages:
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165