SQL> SELECT object_id FROM bc_bcde_index.object LIMIT 1;
|
+------------+
|
| object_id |
|
+------------+
|
| 1 |
|
+------------+
|
SQLRowCount returns 1
|
1 rows fetched
|
SQL> OPTIMIZE TABLE bc_bcde_index.object;
|
+---------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+---------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| bc_bcde_index.object | optimize | note | Table does not support optimize, doing recreate + analyze instead |
|
| bc_bcde_index.object | optimize | status | OK |
|
+---------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
SQLRowCount returns 2
|
2 rows fetched
|
SQL> SELECT object_id FROM bc_bcde_index.object LIMIT 1;
|
+------------+
|
| object_id |
|
+------------+
|
| 1 |
|
+------------+
|
SQLRowCount returns 1
|
1 rows fetched
|