multiple rows in $I table after recreate index online with BIG_IO
Hello,
has anybody similar issues with BIG_IO ?
we've set BIG_IO option for an index the T$I Table looks as follows:
| TOKEN_TEXT | LENGTH(TOKEN_INFO) TOKEN_COUNT |
---------------------------------------------------------------- ------------------ -----------
| DEUTSCHL | 12 | 3 |
| DEUTSCHLA | 13 | 3 |
| DEUTSCHLAD | 8 | 2 |
| DEUTSCHLAN | 18 | 4 |
| DEUTSCHLAND | 565783 | 188027 |
| DEUTSCHLAND | 67 | 15 |
| DEUTSCHLAND-BESUCH | 3 | 1 |
| DEUTSCHLAND-CHEFIN | 3 | 1 |
| DEUTSCHLAND-FLUEGE | 3 | 1 |
after recreating the index online the $I table looks like before BIG_IO option was set:
| TOKEN_TEXT | LENGTH(TOKEN_INFO) TOKEN_COUNT |
---------------------------------------------------------------- ------------------ -----------
| DEUTSCHL | 12 | 3 |
| DEUTSCHLA | 13 | 3 |
| DEUTSCHLAD | 8 | 2 |
| DEUTSCHLAN | 18 | 4 |
| DEUTSCHLAND | 3501 | 1167 |
| DEUTSCHLAND | 3502 | 1167 |
| DEUTSCHLAND | 3501 | 1165 |
| DEUTSCHLAND | 3502 | 1166 |
| DEUTSCHLAND | 3501 | 1166 |
| DEUTSCHLAND | 3502 | 1162 |
| DEUTSCHLAND | 3502 | 1163 |
| DEUTSCHLAND | 3501 | 1163 |
| DEUTSCHLAND | 3502 | 1164 |
| DEUTSCHLAND | 3501 | 1162 |
| DEUTSCHLAND | 3502 | 1162 |
| DEUTSCHLAND | 3502 | 1163 |
is this normal behavior ?
when we run optimize index after recreate BIG_IO is uses again.
0