{"id":1219,"date":"2017-10-29T22:27:22","date_gmt":"2017-10-30T00:27:22","guid":{"rendered":"http:\/\/dbtimewizard.com.br\/blog\/?p=1219"},"modified":"2019-11-11T18:48:26","modified_gmt":"2019-11-11T21:48:26","slug":"o-que-voce-ainda-nao-sabe-sobre-exclusao-de-indices","status":"publish","type":"post","link":"http:\/\/dbtimewizard.com.br\/blog\/o-que-voce-ainda-nao-sabe-sobre-exclusao-de-indices\/","title":{"rendered":"O que voc\u00ea ainda n\u00e3o sabe sobre exclus\u00e3o de \u00edndices?"},"content":{"rendered":"

Uma das tarefas do administrador de banco de dados \u00e9 verificar periodicamente se existem \u00edndices que foram criados mas n\u00e3o est\u00e3o sendo utilizados nos planos de execu\u00e7\u00e3o das instru\u00e7\u00f5es SQL, essa tarefa \u00e9 necess\u00e1ria pois alem de liberar o espa\u00e7o em disco utilizado pelo \u00edndice, tamb\u00e9m contribui para melhoria de desempenho das instru\u00e7\u00f5es DML (Delete, Insert e Update). Para realizar esta tarefa normalmente utilizamos o processo de monitora\u00e7\u00e3o de \u00edndices<\/a>\u00a0<\/strong>que indica quais \u00edndices est\u00e3o sendo utilizados, mas existem alguns cuidados que precisam ser tomados para os \u00edndices indicados por este processo, pois\u00a0ele n\u00e3o identifica a utiliza\u00e7\u00e3o dos \u00edndices acessados por recursive calls, ou seja n\u00e3o podemos excluir os \u00edndices que s\u00e3o utilizados em constraints (Primary Key, Unique Key e Foreign Key). Acredito que todas as informa\u00e7\u00f5es apresentadas at\u00e9 aqui s\u00e3o do conhecimento da maioria das pessoas que trabalham com banco de dados Oracle, porem alem disto existem situa\u00e7\u00f5es em que o Otimizador do Oracle apesar de n\u00e3o utilizar o \u00edndice no plano de execu\u00e7\u00e3o, utiliza as estat\u00edsticas deste \u00edndice e quando\u00a0ele \u00e9 exclu\u00eddo o Otimizar passa a escolher outro plano de execu\u00e7\u00e3o pois j\u00e1 n\u00e3o disp\u00f5e mais destas informa\u00e7\u00f5es estat\u00edsticas. Neste artigo vamos fazer uma demonstra\u00e7\u00e3o pr\u00e1tica de uma destas situa\u00e7\u00f5es e mostrar como podemos excluir o \u00edndice de forma que o Otimizador continue utilizando o mesmo plano de execu\u00e7\u00e3o.<\/span><\/p>\n

Para realizar esta demonstra\u00e7\u00e3o vamos:<\/span><\/strong><\/p>\n

1)\u00a0 Criar 3 tabelas com os respectivos \u00edndices para simula\u00e7\u00e3o da consulta<\/span>
\n2)\u00a0 Executar a consulta com todos os \u00edndices criados <\/span>
\n3) Executar a consulta novamente ap\u00f3s a exclus\u00e3o de um \u00edndice n\u00e3o utilizado no plano de execu\u00e7\u00e3o<\/span>
\n4) Criar estat\u00edsticas estendidas para que o Otimizador mantenha o plano de execu\u00e7\u00e3o original<\/span><\/p>\n

1) Criar as tabelas da\u00a0demonstra\u00e7\u00e3o<\/span><\/h2>\n

 <\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<\/div><\/td>
SQL ><\/span> SELECT *<\/span> FROM V$VERSION<\/span> where rownum <<\/span> 2<\/span>;<\/span>
\n
\nBANNER
\n--------------------------------------------------------------------------------<\/span>
\nOracle Database 11g Enterprise Edition Release 11.<\/span>2.<\/span>0.<\/span>4.<\/span>0 -<\/span> Production
\n
\nSQL ><\/span>
\nSQL ><\/span> CREATE TABLE dbtw1
\n  2<\/span>  AS<\/span>
\n  3<\/span>  SELECT rownum col1,<\/span>
\n  4<\/span>      MOD(<\/span>level,<\/span>  20<\/span>)<\/span> col2,<\/span>
\n  5<\/span>      MOD(<\/span>level,<\/span> 200<\/span>)<\/span> col3,<\/span>
\n  6<\/span>      MOD(<\/span>level,<\/span>1000<\/span>)<\/span> col4,<\/span>
\n  7<\/span>      lpad(<\/span>'x'<\/span>,<\/span>60<\/span>,<\/span>'x'<\/span>)<\/span> col5
\n  8<\/span>  FROM dual
\n  9<\/span>  CONNECT BY level <=<\/span> 10000<\/span>
\n 10<\/span>  \/<\/span>
\n
\nTabela criada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> CREATE TABLE dbtw2
\n  2<\/span>  AS<\/span>
\n  3<\/span>  SELECT rownum col1,<\/span>
\n  4<\/span>      MOD(<\/span>level,<\/span>  20<\/span>)<\/span> col2,<\/span>
\n  5<\/span>      MOD(<\/span>level,<\/span> 200<\/span>)<\/span> col3,<\/span>
\n  6<\/span>      MOD(<\/span>level,<\/span>1000<\/span>)<\/span> col4,<\/span>
\n  7<\/span>      lpad(<\/span>'y'<\/span>,<\/span>60<\/span>,<\/span>'y'<\/span>)<\/span> col5
\n  8<\/span>  FROM dual
\n  9<\/span>  CONNECT BY level <=<\/span> 10<\/span>
\n 10<\/span>  \/<\/span>
\n
\nTabela criada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> CREATE TABLE dbtw3
\n  2<\/span>  AS<\/span>
\n  3<\/span>  SELECT rownum col1,<\/span> lpad(<\/span>'z'<\/span>,<\/span>60<\/span>,<\/span>'z'<\/span>)<\/span> col2
\n  4<\/span>  FROM dual
\n  5<\/span>  CONNECT BY level <=<\/span> 10000<\/span>
\n  6<\/span>  \/<\/span>
\n
\nTabela criada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> EXEC<\/span><\/a> dbms_stats.<\/span>gather_table_stats(<\/span>USER,<\/span>'dbtw1'<\/span>,<\/span>method_opt=><\/span>'for all columns size 1'<\/span>)<\/span>;<\/span>
\n
\nProcedimento PL\/<\/span>SQL conclu\u00eddo<\/span> com sucesso.<\/span>
\n
\nSQL ><\/span> EXEC<\/span><\/a> dbms_stats.<\/span>gather_table_stats(<\/span>USER,<\/span>'dbtw2'<\/span>,<\/span>method_opt=><\/span>'for all columns size 1'<\/span>)<\/span>;<\/span>
\n
\nProcedimento PL\/<\/span>SQL conclu\u00eddo<\/span> com sucesso.<\/span>
\n
\nSQL ><\/span> EXEC<\/span><\/a> dbms_stats.<\/span>gather_table_stats(<\/span>USER,<\/span>'dbtw3'<\/span>,<\/span>method_opt=><\/span>'for all columns size 1'<\/span>)<\/span>;<\/span>
\n
\nProcedimento PL\/<\/span>SQL conclu\u00eddo<\/span> com sucesso.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span>
\nSQL ><\/span> ALTER TABLE dbtw1 ADD CONSTRAINT dbtw1pk PRIMARY KEY<\/span><\/a>(<\/span>col1)<\/span>;<\/span>
\n
\nTabela alterada.<\/span>
\n
\nSQL ><\/span> ALTER TABLE dbtw2 ADD CONSTRAINT dbtw2pk PRIMARY KEY<\/span><\/a>(<\/span>col1)<\/span>;<\/span>
\n
\nTabela alterada.<\/span>
\n
\nSQL ><\/span> ALTER TABLE dbtw3 ADD CONSTRAINT dbtw3pk PRIMARY KEY<\/span><\/a>(<\/span>col1)<\/span>;<\/span>
\n
\nTabela alterada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> CREATE INDEX dbtw1ix ON dbtw1(<\/span>col2,<\/span>col3)<\/span>;<\/span>
\n
\n\u00cdndice criado.<\/span>
\n
\nSQL ><\/span> CREATE INDEX dbtw2ix ON dbtw2(<\/span>col2,<\/span>col3)<\/span>;<\/span>
\n
\n\u00cdndice criado.<\/span>
\n
\nSQL ><\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

 <\/p>\n

2) Executar a consulta com todos os \u00edndices<\/span><\/h2>\n

Vamos executar uma consulta que faz um JOIN das 3 tabelas criadas e verificar que o plano de execu\u00e7\u00e3o n\u00e3o utilizara os \u00edndices que foram criados.<\/span><\/p>\n

 <\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<\/div><\/td>
SQL ><\/span> ALTER SESSION SET statistics_level =<\/span> ALL;<\/span>
\n
\nSess\u00e3o alterada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> WITH visao AS<\/span> (<\/span>
\n  2<\/span>  SELECT t1.<\/span>col5 v1,<\/span>t2.<\/span>col5 v2,<\/span>t3.<\/span>col2 v3
\n  3<\/span>    FROM dbtw1 t1,<\/span>dbtw2 t2,<\/span>dbtw3 t3
\n  4<\/span>   WHERE t1.<\/span>col2 =<\/span> t2.<\/span>col2
\n  5<\/span>     AND t1.<\/span>col3 =<\/span> t2.<\/span>col3
\n  6<\/span>     AND t1.<\/span>col1 =<\/span> t3.<\/span>col1)<\/span>
\n  7<\/span>  select \/* DBTW501 *\/<\/span>  *<\/span> from visao where rownum <<\/span> 51<\/span>;<\/span>
\n
\nV1                                                           V2                                                           V3
\n------------------------------------------------------------<\/span> ------------------------------------------------------------<\/span> ------------------------------------------------------------<\/span>
\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
\n.<\/span>
\n.<\/span>
\n.<\/span>
\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
\n
\n50<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span>
\nSQL ><\/span> --<\/span> Recupera o SQL_ID e o CHILD_NUMBER  da consulta executada
\nSQL ><\/span> column sql_id new_value m_sql_id
\nSQL ><\/span> column child_number new_value m_child_no
\nSQL ><\/span>
\nSQL ><\/span> SELECT sql_id,<\/span> child_number
\n  2<\/span>    FROM v$sql<\/span>
\n  3<\/span>   WHERE sql_text LIKE '%DBTW501%'<\/span>
\n  4<\/span>     AND sql_text NOT LIKE '%v$sql%'<\/span>;<\/span>
\n
\nSQL_ID        CHILD_NUMBER
\n-------------<\/span> ------------<\/span>
\n9bp6g7q3f7293            0<\/span>
\n
\n1<\/span> linha selecionada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> --<\/span> Gera o relat\u00f3rio do<\/span> plano de execu\u00e7\u00e3o da consulta
\nSQL ><\/span> SELECT *<\/span> FROM TABLE (<\/span>dbms_xplan.<\/span>display_cursor (<\/span>'&m_sql_id'<\/span>,&<\/span>m_child_no,<\/span>'typical iostats last'<\/span>)<\/span>)<\/span>;<\/span>
\n
\nPLAN_TABLE_OUTPUT
\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
\nSQL_ID  9bp6g7q3f7293,<\/span> child number 0<\/span>
\n-------------------------------------<\/span>
\nWITH visao AS<\/span> (<\/span> SELECT t1.<\/span>col5 v1,<\/span>t2.<\/span>col5 v2,<\/span>t3.<\/span>col2 v3   FROM dbtw1
\nt1,<\/span>dbtw2 t2,<\/span>dbtw3 t3  WHERE t1.<\/span>col2 =<\/span> t2.<\/span>col2    AND t1.<\/span>col3 =<\/span> t2.<\/span>col3
\n  AND t1.<\/span>col1 =<\/span> t3.<\/span>col1)<\/span> select \/* DBTW501 *\/<\/span>  *<\/span> from visao where
\nrownum <<\/span> :<\/span>"SYS_B_0"<\/span>
\n
\nPlan hash<\/span><\/a> value:<\/span> 137168799<\/span>
\n
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n|<\/span> Id  |<\/span> Operation            |<\/span> Name  |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>Time<\/span><\/a>   |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span>
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT     |<\/span>       |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>     9<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     119<\/span> |<\/span>
\n|*<\/span>  1<\/span> |<\/span>  COUNT<\/span><\/a> STOPKEY       |<\/span>       |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>            |<\/span>          |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     119<\/span> |<\/span>
\n|*<\/span>  2<\/span> |<\/span>   HASH<\/span><\/a> JOIN<\/span><\/a>          |<\/span>       |<\/span>      1<\/span> |<\/span>     50<\/span> |<\/span> 20650<\/span> |<\/span>     9<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     119<\/span> |<\/span>
\n|<\/span>   3<\/span> |<\/span>    TABLE ACCESS FULL |<\/span> DBTW2 |<\/span>      1<\/span> |<\/span>     10<\/span> |<\/span>   670<\/span> |<\/span>     2<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>     10<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>       2<\/span> |<\/span>
\n|*<\/span>  4<\/span> |<\/span>    HASH<\/span><\/a> JOIN<\/span><\/a>         |<\/span>       |<\/span>      1<\/span> |<\/span>   1000<\/span> |<\/span>   204K|<\/span>     7<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>    810<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     117<\/span> |<\/span>
\n|<\/span>   5<\/span> |<\/span>     TABLE ACCESS FULL|<\/span> DBTW3 |<\/span>      1<\/span> |<\/span>  10000<\/span> |<\/span>   634K|<\/span>     5<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>  10000<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     101<\/span> |<\/span>
\n|<\/span>   6<\/span> |<\/span>     TABLE ACCESS FULL|<\/span> DBTW1 |<\/span>      1<\/span> |<\/span>  10000<\/span> |<\/span>   703K|<\/span>     2<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>    810<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>      16<\/span> |<\/span>
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n
\nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
\n---------------------------------------------------<\/span>
\n
\n   1<\/span> -<\/span> filter(<\/span>ROWNUM<:<\/span>SYS_B_0)<\/span>
\n   2<\/span> -<\/span> access(<\/span>"T1"<\/span>.<\/span>"COL2"<\/span>=<\/span>"T2"<\/span>.<\/span>"COL2"<\/span> AND "T1"<\/span>.<\/span>"COL3"<\/span>=<\/span>"T2"<\/span>.<\/span>"COL3"<\/span>)<\/span>
\n   4<\/span> -<\/span> access(<\/span>"T1"<\/span>.<\/span>"COL1"<\/span>=<\/span>"T3"<\/span>.<\/span>"COL1"<\/span>)<\/span>
\n
\n
\n28<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

 <\/p>\n

No plano de execu\u00e7\u00e3o podemos verificar que foram utilizadas duas opera\u00e7\u00f5es HASH JOIN<\/strong> e foram acessados 119 buffers<\/strong>. As estimativas de cardinalidade das opera\u00e7\u00f5es do plano de execu\u00e7\u00e3o podem ser consideradas precisas.\u00a0Para mais informa\u00e7\u00f5es sobre cardinalidade, leia o artigo<\/strong><\/a>.<\/span><\/p>\n

 <\/p>\n

3) Executar a consulta novamente excluindo um \u00edndice<\/span><\/h2>\n

Agora vamos excluir o \u00edndice DBTW1IX, executar a mesma consulta novamente e verificar como ficou o plano de execu\u00e7\u00e3o.<\/span><\/p>\n

 <\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<\/div><\/td>
SQL ><\/span> DROP INDEX dbtw1ix ;<\/span>
\n
\n\u00cdndice eliminado.<\/span>
\n
\nDecorrido:<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>00.32<\/span>
\nSQL ><\/span>
\nSQL ><\/span> ALTER SESSION SET statistics_level =<\/span> ALL;<\/span>
\n
\nSess\u00e3o alterada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span>
\nSQL ><\/span> WITH visao AS<\/span> (<\/span>
\n  2<\/span>  SELECT t1.<\/span>col5 v1,<\/span>t2.<\/span>col5 v2,<\/span>t3.<\/span>col2 v3
\n  3<\/span>    FROM dbtw1 t1,<\/span>dbtw2 t2,<\/span>dbtw3 t3
\n  4<\/span>   WHERE t1.<\/span>col2 =<\/span> t2.<\/span>col2
\n  5<\/span>     AND t1.<\/span>col3 =<\/span> t2.<\/span>col3
\n  6<\/span>     AND t1.<\/span>col1 =<\/span> t3.<\/span>col1)<\/span>
\n  7<\/span>  select \/* DBTW501 *\/<\/span>  *<\/span> from visao where rownum <<\/span> 51<\/span>;<\/span>
\n
\nV1                                                           V2                                                           V3
\n------------------------------------------------------------<\/span> ------------------------------------------------------------<\/span> ------------------------------------------------------------<\/span>
\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
\n.<\/span>
\n.<\/span>
\n.<\/span>
\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
\n
\n50<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> --<\/span> Recupera o SQL_ID e o CHILD_NUMBER  da consulta executada
\nSQL ><\/span> column sql_id new_value m_sql_id
\nSQL ><\/span> column child_number new_value m_child_no
\nSQL ><\/span>
\nSQL ><\/span> SELECT sql_id,<\/span> child_number
\n  2<\/span>    FROM v$sql<\/span>
\n  3<\/span>   WHERE sql_text LIKE '%DBTW501%'<\/span>
\n  4<\/span>     AND sql_text NOT LIKE '%v$sql%'<\/span>;<\/span>
\n
\nSQL_ID        CHILD_NUMBER
\n-------------<\/span> ------------<\/span>
\n9bp6g7q3f7293            0<\/span>
\n
\n1<\/span> linha selecionada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> --<\/span> Gera o relat\u00f3rio do<\/span> plano de execu\u00e7\u00e3o da consulta
\nSQL ><\/span> SELECT *<\/span> FROM TABLE (<\/span>dbms_xplan.<\/span>display_cursor (<\/span>'&m_sql_id'<\/span>,&<\/span>m_child_no,<\/span>'typical iostats last'<\/span>)<\/span>)<\/span>;<\/span>
\n
\nPLAN_TABLE_OUTPUT
\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
\nSQL_ID  9bp6g7q3f7293,<\/span> child number 0<\/span>
\n-------------------------------------<\/span>
\nWITH visao AS<\/span> (<\/span> SELECT t1.<\/span>col5 v1,<\/span>t2.<\/span>col5 v2,<\/span>t3.<\/span>col2 v3   FROM dbtw1
\nt1,<\/span>dbtw2 t2,<\/span>dbtw3 t3  WHERE t1.<\/span>col2 =<\/span> t2.<\/span>col2    AND t1.<\/span>col3 =<\/span> t2.<\/span>col3
\n  AND t1.<\/span>col1 =<\/span> t3.<\/span>col1)<\/span> select \/* DBTW501 *\/<\/span>  *<\/span> from visao where
\nrownum <<\/span> :<\/span>"SYS_B_0"<\/span>
\n
\nPlan hash<\/span><\/a> value:<\/span> 3421279105<\/span>
\n
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n|<\/span> Id  |<\/span> Operation            |<\/span> Name  |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>Time<\/span><\/a>   |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span>
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT     |<\/span>       |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>    13<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     131<\/span> |<\/span>
\n|*<\/span>  1<\/span> |<\/span>  COUNT<\/span><\/a> STOPKEY       |<\/span>       |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>            |<\/span>          |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     131<\/span> |<\/span>
\n|*<\/span>  2<\/span> |<\/span>   HASH<\/span><\/a> JOIN<\/span><\/a>          |<\/span>       |<\/span>      1<\/span> |<\/span>     25<\/span> |<\/span>  5100<\/span> |<\/span>    13<\/span>   (<\/span>8<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     131<\/span> |<\/span>
\n|*<\/span>  3<\/span> |<\/span>    HASH<\/span><\/a> JOIN<\/span><\/a>         |<\/span>       |<\/span>      1<\/span> |<\/span>     25<\/span> |<\/span>  3475<\/span> |<\/span>     7<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>    500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     117<\/span> |<\/span>
\n|<\/span>   4<\/span> |<\/span>     TABLE ACCESS FULL|<\/span> DBTW2 |<\/span>      1<\/span> |<\/span>     10<\/span> |<\/span>   670<\/span> |<\/span>     2<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>     10<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>       2<\/span> |<\/span>
\n|<\/span>   5<\/span> |<\/span>     TABLE ACCESS FULL|<\/span> DBTW1 |<\/span>      1<\/span> |<\/span>  10000<\/span> |<\/span>   703K|<\/span>     5<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>  10000<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     115<\/span> |<\/span>
\n|<\/span>   6<\/span> |<\/span>    TABLE ACCESS FULL |<\/span> DBTW3 |<\/span>      1<\/span> |<\/span>  10000<\/span> |<\/span>   634K|<\/span>     5<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>    810<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>      14<\/span> |<\/span>
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n
\nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
\n---------------------------------------------------<\/span>
\n
\n   1<\/span> -<\/span> filter(<\/span>ROWNUM<:<\/span>SYS_B_0)<\/span>
\n   2<\/span> -<\/span> access(<\/span>"T1"<\/span>.<\/span>"COL1"<\/span>=<\/span>"T3"<\/span>.<\/span>"COL1"<\/span>)<\/span>
\n   3<\/span> -<\/span> access(<\/span>"T1"<\/span>.<\/span>"COL2"<\/span>=<\/span>"T2"<\/span>.<\/span>"COL2"<\/span> AND "T1"<\/span>.<\/span>"COL3"<\/span>=<\/span>"T2"<\/span>.<\/span>"COL3"<\/span>)<\/span>
\n
\n
\n28<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

 <\/p>\n

Como podemos observar acima, ap\u00f3s a exclus\u00e3o do \u00edndice o plano de execu\u00e7\u00e3o ficou diferente, tornou-se menos eficiente pois passou a acessar 131 buffers<\/strong> para trazer as mesmas 50 linhas. Podemos observar que na opera\u00e7\u00e3o ID 3 HASH JOIN<\/strong>\u00a0a cardinalidade estimada E-ROWS=25<\/strong> foi muito diferente da cardinalidade real da opera\u00e7\u00e3o A-ROWS=500<\/strong>, o Otimizador errou feio na estimativa pois\u00a0n\u00e3o teve acesso as informa\u00e7\u00f5es estat\u00edsticas do \u00edndice DBTW1IX<\/strong> que fornecia as estat\u00edsticas das colunas COL2<\/strong> e COL3<\/strong> da tabela DBTW1<\/strong>\u00a0utilizadas na cl\u00e1usula WHERE para fazer a jun\u00e7\u00e3o das tabelas.<\/span><\/p>\n

4) Fornecer as estat\u00edsticas necess\u00e1rias para manuten\u00e7\u00e3o do plano otimizado<\/span><\/h2>\n

Como vimos acima a exclus\u00e3o do \u00edndice DBTW1IX<\/strong> eliminou tamb\u00e9m estat\u00edsticas muito importantes para que o Otimizador pudesse realizar o seu trabalho de forma adequada mantendo o desempenho da consulta. Para eliminar este \u00edndice que n\u00e3o esta sendo utilizado e preservar as estat\u00edsticas adequadas para o Otimizador podemos criar estat\u00edsticas estendidas das colunas referenciadas no \u00edndice.<\/span><\/p>\n

 <\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<\/div><\/td>
SQL ><\/span> SELECT dbms_stats.<\/span>create_extended_stats(<\/span>NULL<\/span>,<\/span>'DBTW1'<\/span>,<\/span>'(col2,col3)'<\/span>)<\/span> FROM dual;<\/span>
\n
\nDBMS_STATS.<\/span>CREATE_EXTENDED_STATS(<\/span>NULL<\/span>,<\/span>'DBTW1'<\/span>,<\/span>'(COL2,COL3)'<\/span>)<\/span>
\n--------------------------------------------------------------------------------------<\/span>
\nSYS_STUIZDYGR9#LTMLSM7RCAPTD02
\n<\/span>
\n1<\/span> linha selecionada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> SELECT column_name,<\/span> num_distinct,<\/span> histogram
\n  2<\/span>    FROM   user_tab_col_statistics
\n  3<\/span>   WHERE  TABLE_NAME =<\/span> 'DBTW1'<\/span>;<\/span>
\n
\nCOLUMN_NAME                    NUM_DISTINCT HISTOGRAM
\n------------------------------<\/span> ------------<\/span> ---------------<\/span>
\nCOL1                                  10000<\/span> NONE
\nCOL2                                     20<\/span> NONE
\nCOL3                                    200<\/span> NONE
\nCOL4                                   1000<\/span> NONE
\nCOL5                                      1<\/span> NONE
\n
\n5<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span>
\nSQL ><\/span> col extension_name FOR<\/span> a40
\nSQL ><\/span> col extension FOR<\/span> a40
\nSQL ><\/span> SELECT extension_name,<\/span> extension
\n  2<\/span>    FROM   user_stat_extensions
\n  3<\/span>   WHERE  TABLE_NAME =<\/span> 'DBTW1'<\/span>;<\/span>
\n
\nEXTENSION_NAME                           EXTENSION
\n----------------------------------------<\/span> ----------------------------------------<\/span>
\nSYS_STUIZDYGR9#LTMLSM7RCAPTD02           ("COL2","COL3")
\n<\/span>
\n1<\/span> linha selecionada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> EXEC<\/span><\/a> dbms_stats.<\/span>gather_table_stats(<\/span>NULL<\/span>,<\/span>'DBTW1'<\/span>,<\/span>method_opt=><\/span>'for all columns size 1'<\/span>)<\/span>;<\/span>
\n
\nProcedimento PL\/<\/span>SQL conclu\u00eddo<\/span> com sucesso.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span>
\nSQL ><\/span> SELECT column_name,<\/span> num_distinct,<\/span> histogram
\n  2<\/span>    FROM   user_tab_col_statistics
\n  3<\/span>   WHERE  TABLE_NAME =<\/span> 'DBTW1'<\/span>;<\/span>
\n
\nCOLUMN_NAME                    NUM_DISTINCT HISTOGRAM
\n------------------------------<\/span> ------------<\/span> ---------------<\/span>
\nCOL1                                  10000<\/span> NONE
\nCOL2                                     20<\/span> NONE
\nCOL3                                    200<\/span> NONE
\nCOL4                                   1000<\/span> NONE
\nCOL5                                      1<\/span> NONE
\nSYS_STUIZDYGR9#LTMLSM7RCAPTD02          200 NONE
\n<\/span>
\n6<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

 <\/p>\n

Acima utilizamos o pacote DBMS_STATS<\/strong> e os procedimentos CREATE_EXTENDED_STATS<\/strong> e GATHER_TABLE_STATS<\/strong> para recriar as estat\u00edsticas\u00a0que existiam\u00a0em fun\u00e7\u00e3o do \u00edndice que foi eliminado. Na sequ\u00eancia vamos executar a mesma consulta novamente e verificar se o Otimizador volta a utilizar o melhor plano de execu\u00e7\u00e3o. Para mais informa\u00e7\u00f5es sobre estat\u00edsticas estendidas consulte o artigo<\/a>.<\/strong><\/span><\/p>\n

 <\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<\/div><\/td>
SQL ><\/span> ALTER SESSION SET statistics_level =<\/span> ALL;<\/span>
\n
\nSess\u00e3o alterada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span>
\nSQL ><\/span> WITH visao AS<\/span> (<\/span>
\n  2<\/span>  SELECT t1.<\/span>col5 v1,<\/span>t2.<\/span>col5 v2,<\/span>t3.<\/span>col2 v3
\n  3<\/span>    FROM dbtw1 t1,<\/span>dbtw2 t2,<\/span>dbtw3 t3
\n  4<\/span>   WHERE t1.<\/span>col2 =<\/span> t2.<\/span>col2
\n  5<\/span>     AND t1.<\/span>col3 =<\/span> t2.<\/span>col3
\n  6<\/span>     AND t1.<\/span>col1 =<\/span> t3.<\/span>col1)<\/span>
\n  7<\/span>  select \/* DBTW502 *\/<\/span>  *<\/span> from visao where rownum <<\/span> 51<\/span>;<\/span>
\n
\nV1                                                           V2                                                           V3
\n------------------------------------------------------------<\/span> ------------------------------------------------------------<\/span> ------------------------------------------------------------<\/span>
\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
\n.<\/span>
\n.<\/span>
\n.<\/span>
\nxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
\n
\n50<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> --<\/span> Recupera o SQL_ID e o CHILD_NUMBER  da consulta executada
\nSQL ><\/span> column sql_id new_value m_sql_id
\nSQL ><\/span> column child_number new_value m_child_no
\nSQL ><\/span>
\nSQL ><\/span> SELECT sql_id,<\/span> child_number
\n  2<\/span>    FROM v$sql<\/span>
\n  3<\/span>   WHERE sql_text LIKE '%DBTW502%'<\/span>
\n  4<\/span>     AND sql_text NOT LIKE '%v$sql%'<\/span>;<\/span>
\n
\nSQL_ID        CHILD_NUMBER
\n-------------<\/span> ------------<\/span>
\n0tyzfn1f8n2q7            0<\/span>
\n
\n1<\/span> linha selecionada.<\/span>
\n
\nSQL ><\/span>
\nSQL ><\/span> --<\/span> Gera o relat\u00f3rio do<\/span> plano de execu\u00e7\u00e3o da consulta
\nSQL ><\/span> SELECT *<\/span> FROM TABLE (<\/span>dbms_xplan.<\/span>display_cursor (<\/span>'&m_sql_id'<\/span>,&<\/span>m_child_no,<\/span>'typical iostats last'<\/span>)<\/span>)<\/span>;<\/span>
\n
\nPLAN_TABLE_OUTPUT
\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
\nSQL_ID  0tyzfn1f8n2q7,<\/span> child number 0<\/span>
\n-------------------------------------<\/span>
\nWITH visao AS<\/span> (<\/span> SELECT t1.<\/span>col5 v1,<\/span>t2.<\/span>col5 v2,<\/span>t3.<\/span>col2 v3   FROM dbtw1
\nt1,<\/span>dbtw2 t2,<\/span>dbtw3 t3  WHERE t1.<\/span>col2 =<\/span> t2.<\/span>col2    AND t1.<\/span>col3 =<\/span> t2.<\/span>col3
\n  AND t1.<\/span>col1 =<\/span> t3.<\/span>col1)<\/span> select \/* DBTW502 *\/<\/span>  *<\/span> from visao where
\nrownum <<\/span> :<\/span>"SYS_B_0"<\/span>
\n
\nPlan hash<\/span><\/a> value:<\/span> 137168799<\/span>
\n
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n|<\/span> Id  |<\/span> Operation            |<\/span> Name  |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>Time<\/span><\/a>   |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span>
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT     |<\/span>       |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>     9<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     119<\/span> |<\/span>
\n|*<\/span>  1<\/span> |<\/span>  COUNT<\/span><\/a> STOPKEY       |<\/span>       |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>            |<\/span>          |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     119<\/span> |<\/span>
\n|*<\/span>  2<\/span> |<\/span>   HASH<\/span><\/a> JOIN<\/span><\/a>          |<\/span>       |<\/span>      1<\/span> |<\/span>     50<\/span> |<\/span> 20650<\/span> |<\/span>     9<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>     50<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     119<\/span> |<\/span>
\n|<\/span>   3<\/span> |<\/span>    TABLE ACCESS FULL |<\/span> DBTW2 |<\/span>      1<\/span> |<\/span>     10<\/span> |<\/span>   670<\/span> |<\/span>     2<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>     10<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>       2<\/span> |<\/span>
\n|*<\/span>  4<\/span> |<\/span>    HASH<\/span><\/a> JOIN<\/span><\/a>         |<\/span>       |<\/span>      1<\/span> |<\/span>   1000<\/span> |<\/span>   204K|<\/span>     7<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>    810<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     117<\/span> |<\/span>
\n|<\/span>   5<\/span> |<\/span>     TABLE ACCESS FULL|<\/span> DBTW3 |<\/span>      1<\/span> |<\/span>  10000<\/span> |<\/span>   634K|<\/span>     5<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>  10000<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>     101<\/span> |<\/span>
\n|<\/span>   6<\/span> |<\/span>     TABLE ACCESS FULL|<\/span> DBTW1 |<\/span>      1<\/span> |<\/span>  10000<\/span> |<\/span>   703K|<\/span>     2<\/span>   (<\/span>0<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>01<\/span> |<\/span>    810<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>      16<\/span> |<\/span>
\n------------------------------------------------------------------------------------------------------------------------<\/span>
\n
\nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
\n---------------------------------------------------<\/span>
\n
\n   1<\/span> -<\/span> filter(<\/span>ROWNUM<:<\/span>SYS_B_0)<\/span>
\n   2<\/span> -<\/span> access(<\/span>"T1"<\/span>.<\/span>"COL2"<\/span>=<\/span>"T2"<\/span>.<\/span>"COL2"<\/span> AND "T1"<\/span>.<\/span>"COL3"<\/span>=<\/span>"T2"<\/span>.<\/span>"COL3"<\/span>)<\/span>
\n   4<\/span> -<\/span> access(<\/span>"T1"<\/span>.<\/span>"COL1"<\/span>=<\/span>"T3"<\/span>.<\/span>"COL1"<\/span>)<\/span>
\n
\n
\n28<\/span> linhas selecionadas.<\/span>
\n
\nSQL ><\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

 <\/p>\n

Ap\u00f3s a recria\u00e7\u00e3o das estat\u00edsticas das colunas referenciadas no \u00edndice que foi exclu\u00eddo, o Otimizador voltou a estimar a cardinalidade das opera\u00e7\u00f5es com maior precis\u00e3o e voltou a utilizar o mesmo plano de execu\u00e7\u00e3o utilizado pela consulta antes da exclus\u00e3o do \u00edndice.<\/span><\/p>\n

Refer\u00eancias:<\/span><\/h2>\n

http:\/\/mytracelog.blogspot.com.br\/2011\/09\/monitorando-o-uso-de-indice-no-oracle.html<\/a><\/span><\/strong><\/p>\n

 <\/p>\n

 
\n\"Promo-D75L\"<\/a><\/p>\n

\"video-02\"<\/a>
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n 
\n <\/p>\n","protected":false},"excerpt":{"rendered":"

Uma das tarefas do administrador de banco de dados \u00e9 verificar periodicamente se existem \u00edndices que foram criados mas n\u00e3o est\u00e3o sendo utilizados nos planos de execu\u00e7\u00e3o das instru\u00e7\u00f5es SQL, essa tarefa \u00e9 necess\u00e1ria pois alem de liberar o espa\u00e7o em disco utilizado pelo \u00edndice, tamb\u00e9m contribui para melhoria de desempenho das instru\u00e7\u00f5es DML (Delete, Insert e Update). Para realizar<\/p>\n","protected":false},"author":2,"featured_media":1218,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62],"tags":[181,183,182,179,180,184],"class_list":["post-1219","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-indice","tag-create_extended_stats","tag-drop-index","tag-estatisticas-estendidas","tag-index-monitoring","tag-monitoracao-indices","tag-unused-index"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/comments?post=1219"}],"version-history":[{"count":36,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":2080,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/1219\/revisions\/2080"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/media\/1218"}],"wp:attachment":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}