Shulou(Shulou.com)06/02 Report--

Ops$admin@CRMG > explain plan for

2 create index ttt on aaaa (id)

Explained.

Ops$admin@CRMG > @ display

PLAN_TABLE_OUTPUT

- -

Plan hash value: 2861610204

| | Id | Operation | Name | Rows | Bytes | Cost (% CPU) | Time |

| | 0 | CREATE INDEX STATEMENT | | 409 | 5317 | 4 (0) | 00:00:01 |

| | 1 | INDEX BUILD NON UNIQUE | TTT |

| | 2 | SORT CREATE INDEX | | 409 | 5317 | |

| | 3 | TABLE ACCESS FULL | AAAA | 409 | 5317 | 3 (0) | 00:00:01 |

Note

-

-estimated index size: 65536 bytes

14 rows selected.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.