{"id":2009,"date":"2015-11-10T01:08:32","date_gmt":"2015-11-10T01:08:31","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2009"},"modified":"2023-06-27T07:18:46","modified_gmt":"2023-06-27T14:18:46","slug":"covering-indexes-for-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/covering-indexes-for-n1ql\/","title":{"rendered":"Cobrindo \u00edndices no 4.1 Developer Preview: voc\u00ea est\u00e1 \"coberto\""},"content":{"rendered":"

Com o servidor Couchbase <\/span>4,0 GA <\/span><\/a>- apresentamos a voc\u00ea o N1QL, que foi um facilitador essencial para desenvolver com agilidade e operar em escala! Agora, temos o prazer de anunciar o <\/span>vers\u00e3o pr\u00e9via para desenvolvedores do 4.1<\/span><\/a> - que tem corre\u00e7\u00f5es de estabilidade valiosas. Dentro disso, h\u00e1 um recurso importante chamado Covering Indexes. <\/span><\/p>\n

O Covering Index \u00e9 um novo e empolgante recurso do N1QL na vers\u00e3o 4.1 que permite que um aplicativo, que o aproveite adequadamente, reconhe\u00e7a uma melhoria not\u00e1vel no desempenho da consulta em muitos casos. Uma consulta coberta \u00e9 uma consulta N1QL na qual todos os campos da consulta fazem parte de um \u00edndice, e todos os campos retornados na consulta est\u00e3o no mesmo \u00edndice.<\/span><\/p>\n

Antes desse aprimoramento, se voc\u00ea der uma olhada no fluxo de execu\u00e7\u00e3o da consulta, ele \u00e9 o seguinte:<\/span><\/p>\n

    \n
  1. \n

    O cliente do aplicativo emite uma solicita\u00e7\u00e3o de consulta ao servidor por meio de uma API Rest<\/span><\/p>\n<\/li>\n

  2. \n

    O servi\u00e7o de consulta passa por uma fase de an\u00e1lise e an\u00e1lise e gera um plano de consulta.<\/span><\/p>\n<\/li>\n

  3. \n

    O servi\u00e7o de consulta emite solicita\u00e7\u00f5es de varredura para o servi\u00e7o de \u00edndice se houver um \u00edndice v\u00e1lido para a situa\u00e7\u00e3o<\/span><\/p>\n<\/li>\n

  4. \n

    Obt\u00e9m de volta as chaves de documento qualificadas do servi\u00e7o Index<\/span><\/p>\n<\/li>\n

  5. \n

    Envia as chaves do documento para o Data Service (uma \"solicita\u00e7\u00e3o de busca\")<\/span><\/p>\n<\/li>\n

  6. \n

    Obt\u00e9m os documentos de volta do Data Service<\/span><\/p>\n<\/li>\n

  7. \n

    Avalia os documentos (reaplica os crit\u00e9rios de filtragem etc.)<\/span><\/p>\n<\/li>\n

  8. \n

    Envia os resultados finais filtrados de volta ao cliente<\/span><\/p>\n<\/li>\n<\/ol>\n

    Em um aplicativo bem projetado, as etapas 5 e 6 podem ser evitadas usando um \u00edndice de cobertura (que recomendamos como pr\u00e1tica recomendada), o que pode resultar em uma melhoria de desempenho demonstr\u00e1vel.<\/span><\/p>\n

    A instru\u00e7\u00e3o EXPLAIN no N1QL permite que voc\u00ea veja o plano de execu\u00e7\u00e3o da consulta. Quando um \u00edndice de cobertura \u00e9 usado para a execu\u00e7\u00e3o da consulta, o EXPLAIN agora mostrar\u00e1 que um \u00edndice de cobertura \u00e9 usado para acesso aos dados (e as buscas de documentos de valor-chave e a sobrecarga associada s\u00e3o evitadas).<\/span><\/p>\n

    Digamos que criemos um \u00edndice sobre o atributo \"state\" (estado) no bucket de amostras de cerveja.<\/span><\/p>\n

    CREATE INDEX idxstate ON `beer-sample`(state) USING GSI<\/span><\/p>\n

    Agora, se selecionarmos o estado de beer-sample, como todos os dados a serem retornados est\u00e3o presentes no \u00edndice, poderemos evitar a busca de dados de valor-chave e apenas retornar os dados com base no \u00edndice.<\/span><\/p>\n

    EXPLAIN SELECT state FROM `beer-sample\u2019 WHERE state = \u201cCA\u201d<\/span><\/p>\n

    \"results\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"Sequence\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"~children\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“#operator”: “<\/span>IndexScan<\/span>“,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"covers\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“cover((`beer-sample`.`state`))”<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“index”: “idxstate”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“keyspace”: “beer-sample”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"namespace\": \"default\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"spans\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Range\": {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Alto\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“”CA””<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Inclus\u00e3o\": 3,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Low\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“”CA””<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>]<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"using\": \"gsi\"<\/span><\/p>\n

    Observa\u00e7\u00e3o:<\/span> O mesmo \u00edndice N\u00c3O \u00e9 um \u00edndice de cobertura se a consulta for ligeiramente modificada.<\/span><\/p>\n

    EXPLAIN SELECT state, city FROM `beer-sample` WHERE STATE = “CA”;<\/span><\/p>\n

    Ele ainda usa o \u00edndice idxstate, por\u00e9m, como o \u00edndice N\u00c3O cont\u00e9m as informa\u00e7\u00f5es da cidade, ele usa o \u00edndice para uma pesquisa mais r\u00e1pida, mas n\u00e3o como um \u00edndice de cobertura.<\/span><\/p>\n

    {<\/span><\/p>\n

    \u00a0\u00a0\u00a0 <\/span>“requestID”: “c60b10d2-2cab-4b6a-987c-e5e6ebe4a900”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0 <\/span>\"signature\" (assinatura): \"json\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0 <\/span>\"results\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"Sequence\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"~children\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“#operator”: “<\/span>IndexScan<\/span>“,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“index”: “idxstate”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“keyspace”: “beer-sample”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"namespace\": \"default\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"spans\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Range\": {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Alto\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“”CA””<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Inclus\u00e3o\": 3,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Low\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“”CA””<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>]<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"using\": \"gsi\"<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>},<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"Paralelo\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"~child\": {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"Sequence\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"~children\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“<\/span>#operator”: “Fetch”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“keyspace”: “beer-sample”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"namespace\": \"default\"<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>},<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"Filter\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“condition”: “((`beer-sample`.`state`) = “CA”)”<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>},<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"InitialProject\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"result_terms\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“expr”: “(`beer-sample`.`state`)”<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>},<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“expr”: “(`beer-sample`.`city`)”<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>]<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>},<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"FinalProject\"<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>]…rest omitted for brevity<\/span><\/p>\n

    Como podemos ent\u00e3o converter essa consulta modificada para usar um \u00edndice de cobertura?<\/span>
    Aqui est\u00e1,<\/span><\/p>\n

    CREATE INDEX idxstatecity ON `beer-sample` (state, city) USING GSI<\/span><\/p>\n

    Agora, se executarmos a consulta:<\/span><\/p>\n

    EXPLAIN SELECT estado, cidade <\/span><\/p>\n

    FROM `beer-sample` USE INDEX (idxstatecity) <\/span><\/p>\n

    WHERE STATE = “CA” ;<\/span><\/p>\n

    Bingo! Ela se torna uma consulta que usa um \u00edndice de cobertura<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"#operator\": \"IndexScan\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"covers\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“cover((meta(`beer-sample`).`id`))”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“cover((`beer-sample`.`state`))”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“cover((`beer-sample`.`city`))”<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“index”: “idxstatecity”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“keyspace”: “beer-sample”,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"namespace\": \"default\",<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"spans\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>{<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Range\": {<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Alto\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“successor(“CA”)”<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Inclus\u00e3o\": 1,<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"Low\": [<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>“”CA””<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>]<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>}<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>],<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>\"using\": \"gsi\"<\/span><\/p>\n

    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\u00a0\u00a0\u00a0 <\/span>},<\/span><\/p>\n

    \u00a0\u00a0<\/span><\/p>\n

    EXPRESS\u00d5ES E AGREGADOS<\/span><\/p>\n

    As consultas com express\u00f5es e agregados tamb\u00e9m podem se beneficiar do \u00edndice de cobertura.<\/span><\/p>\n

    CREATE INDEX idxstatecountry ON `beer-sample`(state, country) USING GSI<\/span><\/p>\n

    SELECT country, max(state) <\/span><\/p>\n

    FROM `beer-sample` USE INDEX (idxstatecountry)<\/span><\/p>\n

    WHERE STATE LIKE ‘%’ <\/span><\/p>\n

    GROUP BY country<\/span><\/p>\n

    UNI\u00c3O \/ INTERSE\u00c7\u00c3O \/ EXCE\u00c7\u00c3O <\/span><\/p>\n

    Tamb\u00e9m h\u00e1 suporte para esses \u00edndices de cobertura<\/span><\/p>\n

    SELECIONAR PA\u00cdS <\/span><\/p>\n

    FROM `beer-sample` <\/span><\/p>\n

    WHERE STATE = ‘CA’<\/span><\/p>\n

    UNION ALL<\/span><\/p>\n

    SELECIONAR PA\u00cdS <\/span><\/p>\n

    FROM `beer-sample` <\/span><\/p>\n

    WHERE STATE = 'Texas'<\/span><\/p>\n

    E como o \u00edndice j\u00e1 est\u00e1 classificado, quando voc\u00ea usa ORDER BY no caso de um \u00edndice de cobertura, h\u00e1 o benef\u00edcio adicional de o mecanismo de consulta j\u00e1 poder usar um \u00edndice classificado.<\/span><\/p>\n

    Consulte nosso <\/span>documenta\u00e7\u00e3o<\/span><\/a> para obter mais informa\u00e7\u00f5es e outros cen\u00e1rios em que os \u00edndices de cobertura ser\u00e3o \u00fateis para voc\u00ea. <\/span><\/p>\n

    Recomendamos enfaticamente que voc\u00ea experimente esse recurso na visualiza\u00e7\u00e3o para desenvolvedores da vers\u00e3o 4.1 e nos d\u00ea seu valioso feedback. <\/span>feedback<\/span><\/a>. <\/span><\/p>\n

    Voc\u00ea tamb\u00e9m pode experimentar o N1QL usando o Developer Preview do <\/span>Workbench de consulta<\/span><\/a>que fornece uma boa GUI para escrever e executar consultas N1QL.<\/span><\/p>","protected":false},"excerpt":{"rendered":"

    With the Couchbase Server 4.0 GA – we gave you N1QL which was a key enabler to Develop with Agility, and Operate at Scale! Now, we are pleased to announce the developer preview release of 4.1 – which has valuable […]<\/p>","protected":false},"author":39,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"ppma_author":[9020],"class_list":["post-2009","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"yoast_head":"\nCovering Indexes in 4.1 Developer Preview Release<\/title>\n<meta name=\"description\" content=\"Learn more about the new feature "Covering Indexes" embedded in the developer preview release of 4.1 which has valuable stability fixe\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/pt\/covering-indexes-for-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Covering Indexes in 4.1 Developer Preview : We\u2019ve got you \u201ccovered\u201d\" \/>\n<meta property=\"og:description\" content=\"Learn more about the new feature "Covering Indexes" embedded in the developer preview release of 4.1 which has valuable stability fixe\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/covering-indexes-for-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-10T01:08:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-27T14:18:46+00:00\" \/>\n<meta name=\"author\" content=\"Ilam Siva, SR. Product Manager, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ilam Siva, SR. Product Manager, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/\"},\"author\":{\"name\":\"Ilam Siva, SR. Product Manager, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b28482a2be0617cc239914487f3873af\"},\"headline\":\"Covering Indexes in 4.1 Developer Preview : We\u2019ve got you \u201ccovered\u201d\",\"datePublished\":\"2015-11-10T01:08:31+00:00\",\"dateModified\":\"2023-06-27T14:18:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/\"},\"wordCount\":782,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/\",\"name\":\"Covering Indexes in 4.1 Developer Preview Release\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2015-11-10T01:08:31+00:00\",\"dateModified\":\"2023-06-27T14:18:46+00:00\",\"description\":\"Learn more about the new feature \\\"Covering Indexes\\\" embedded in the developer preview release of 4.1 which has valuable stability fixe\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Covering Indexes in 4.1 Developer Preview : We\u2019ve got you \u201ccovered\u201d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b28482a2be0617cc239914487f3873af\",\"name\":\"Ilam Siva, SR. Product Manager, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/7e4a688afe7b38f57aa80ec35aaabe6b\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g\",\"caption\":\"Ilam Siva, SR. Product Manager, Couchbase\"},\"description\":\"A former Senior Product Manager at Couchbase, Ilam Siva is responsible for various areas of Couchbase Server product development, roadmap, positioning, messaging and collateral. Ilam is passionate about Big Data and NoSQL and believes that it will push the frontiers of scale, performance and capabilities of next generation applications. Prior to Couchbase, he has worked on Hadoop, Cloud platform and database technologies at Yahoo!, Microsoft and Oracle.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/ilam-siva\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Covering Indexes in 4.1 Developer Preview Release","description":"Learn more about the new feature \"Covering Indexes\" embedded in the developer preview release of 4.1 which has valuable stability fixe","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/pt\/covering-indexes-for-n1ql\/","og_locale":"pt_BR","og_type":"article","og_title":"Covering Indexes in 4.1 Developer Preview : We\u2019ve got you \u201ccovered\u201d","og_description":"Learn more about the new feature \"Covering Indexes\" embedded in the developer preview release of 4.1 which has valuable stability fixe","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/covering-indexes-for-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2015-11-10T01:08:31+00:00","article_modified_time":"2023-06-27T14:18:46+00:00","author":"Ilam Siva, SR. Product Manager, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ilam Siva, SR. Product Manager, Couchbase","Est. reading time":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/"},"author":{"name":"Ilam Siva, SR. Product Manager, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b28482a2be0617cc239914487f3873af"},"headline":"Covering Indexes in 4.1 Developer Preview : We\u2019ve got you \u201ccovered\u201d","datePublished":"2015-11-10T01:08:31+00:00","dateModified":"2023-06-27T14:18:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/"},"wordCount":782,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Uncategorized"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/","name":"Covering Indexes in 4.1 Developer Preview Release","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2015-11-10T01:08:31+00:00","dateModified":"2023-06-27T14:18:46+00:00","description":"Learn more about the new feature \"Covering Indexes\" embedded in the developer preview release of 4.1 which has valuable stability fixe","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/covering-indexes-for-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Covering Indexes in 4.1 Developer Preview : We\u2019ve got you \u201ccovered\u201d"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b28482a2be0617cc239914487f3873af","name":"Ilam Siva, SR. Gerente de produtos, Couchbase","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/7e4a688afe7b38f57aa80ec35aaabe6b","url":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g","caption":"Ilam Siva, SR. Product Manager, Couchbase"},"description":"Ex-gerente s\u00eanior de produtos da Couchbase, Ilam Siva \u00e9 respons\u00e1vel por v\u00e1rias \u00e1reas de desenvolvimento de produtos, roteiro, posicionamento, mensagens e garantias do Couchbase Server. Ilam \u00e9 apaixonado por Big Data e NoSQL e acredita que eles ampliar\u00e3o as fronteiras da escala, do desempenho e dos recursos dos aplicativos da pr\u00f3xima gera\u00e7\u00e3o. Antes da Couchbase, ele trabalhou com Hadoop, plataforma de nuvem e tecnologias de banco de dados no Yahoo!, Microsoft e Oracle.","url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/ilam-siva\/"}]}},"authors":[{"term_id":9020,"user_id":39,"is_guest":0,"slug":"ilam-siva","display_name":"Ilam Siva, SR. Product Manager, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/1616892157452a8a9259927dfbef19ba8b3062e91308f39e46efce3f03738746?s=96&d=mm&r=g","author_category":"","last_name":"Siva","first_name":"Ilam","job_title":"","user_url":"","description":"Ex-gerente s\u00eanior de produtos da Couchbase, Ilam Siva \u00e9 respons\u00e1vel por v\u00e1rias \u00e1reas de desenvolvimento de produtos, roteiro, posicionamento, mensagens e garantias do Couchbase Server. Ilam \u00e9 apaixonado por Big Data e NoSQL e acredita que eles ampliar\u00e3o as fronteiras da escala, do desempenho e dos recursos dos aplicativos da pr\u00f3xima gera\u00e7\u00e3o. Antes da Couchbase, ele trabalhou com Hadoop, plataforma de nuvem e tecnologias de banco de dados no Yahoo!, Microsoft e Oracle."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/2009","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=2009"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/2009\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=2009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=2009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=2009"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=2009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}