From user-return-28152-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu Aug 16 19:14:03 2012 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F359FD275 for ; Thu, 16 Aug 2012 19:14:02 +0000 (UTC) Received: (qmail 18856 invoked by uid 500); 16 Aug 2012 19:14:00 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 18833 invoked by uid 500); 16 Aug 2012 19:14:00 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 18824 invoked by uid 99); 16 Aug 2012 19:14:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2012 19:14:00 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of s5alye@gmail.com designates 209.85.160.172 as permitted sender) Received: from [209.85.160.172] (HELO mail-gh0-f172.google.com) (209.85.160.172) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2012 19:13:54 +0000 Received: by ghbg16 with SMTP id g16so3605335ghb.31 for ; Thu, 16 Aug 2012 12:13:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=7Bf6ucJ104fRSkgVT+2ZFEmP39c2AxjaOjwsIINfhrs=; b=uUqTZmHSL9yu1YW2tjPazWO6nFMJ08LtASRp5R1Q2nbIsXf+gl2392rNgCwiSbhZwY 3G6wAf2hmVxiMSPlRuaWUyPphatnSjV0yBK6loVxe6uwOuFXgFygSOO2twYP8GngUk6w NFxxDsUCeFXN73IjdgxOlqxxVvIEZ7VXK4taof32gf+27IvLnPjLvTInaDiC1zJhCmZd HPUm7pQcexnx6cMa/AwpjqVcoCcGppsbKxKLQK5VRsT8UvGyduMpLG6BWaoIVhJOxz57 ioogznbc7BMIBa9Kg43X5/KWaik1+9Z1Bci98DXv2PlnHbrB3cvc8yyZbIiAnE+H7IOa RGLg== MIME-Version: 1.0 Received: by 10.60.28.101 with SMTP id a5mr1887086oeh.69.1345144413514; Thu, 16 Aug 2012 12:13:33 -0700 (PDT) Received: by 10.182.57.169 with HTTP; Thu, 16 Aug 2012 12:13:33 -0700 (PDT) Date: Thu, 16 Aug 2012 15:13:33 -0400 Message-ID: Subject: 'WHERE' with several indexed columns From: A J To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi If I have a WHERE clause in CQL with several 'AND' and each column is indexed, which index(es) is(are) used ? Just the first field in the where clause or all the indexes involved in the clause ? Also is index used only with an equality operator or also with greater than /less than comparator as well ? Thanks.