SQL Profile 实验01
##创建测试表和数据SQL> conn scott/tiger;Connected.SQL> create table t1 as select * from all_objects where rownum<=50000;Table created.SQL> create table t2 as select * from all_objects where rownum<=50000;Table created.##开启autotrace 并执行SQLSQL> set autotrace trace explain;SQL>SELECT *&n...
zabbix表分区详细步骤
1、连接数据库 mysql -h <database_ip/fqdn> -u<user> -p Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> use zabbix; Reading table information for completion of ...