Oracle Database Query and index creation

The oracle database query and index creation system contains a log table that records logon and logout. After a long time, the data volume is large and there is no historical table. When the client logs on, it will go to the database to query the IP address and time of the user's last logon. Because there is no index, it is very slow sometimes. Therefore, you need to add an index to this table. To improve the query efficiency, first check which indexes exist in the table.
SQL code select index_name from all_indexes where table_name = 'syslog ';
If the index of the specified field does not exist, create
SQL code create index PK_SYSLOG on M_TRADERLOG (id); Author: www.2cto.com