Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 66464 invoked from network); 14 Apr 2011 16:33:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Apr 2011 16:33:26 -0000 Received: (qmail 84098 invoked by uid 500); 14 Apr 2011 16:33:24 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 84074 invoked by uid 500); 14 Apr 2011 16:33:24 -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 84066 invoked by uid 99); 14 Apr 2011 16:33:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Apr 2011 16:33:24 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates 209.85.220.172 as permitted sender) Received: from [209.85.220.172] (HELO mail-vx0-f172.google.com) (209.85.220.172) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Apr 2011 16:33:20 +0000 Received: by vxg33 with SMTP id 33so1805433vxg.31 for ; Thu, 14 Apr 2011 09:32:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=H2dgP/RK42ulXb92QoBlfgoEs1123mD6Ed6TH/XtSgQ=; b=Xr25xiYyZPCQjjpZjaZ+ZJxoXbIFJAtiTQYxGTc5u0n8lXA+j67XmPkOmY3HIvGg5d ZDUnRzhH7tr9rL/rljcwd30jpZrfCGprOrzE8A50Zavy9qY5RhUzyxjVCb+C5zAJRqB2 jVgaSymQEDqmGOOFYu+p/jxmJ5A9jSQgF8kOY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=XjttDxWV6nyAsL4e68HgJp/UqLZxqil+lUIrd+Y3LueTmrQ70qbUpHQ+M7P0tNYHMW 03GNkEU2ZSQE+PvgJlsJL5OR42RQoXBww83SsvnA3wDehpYzEzXK8pYm3hO7m1dUM5OY xNqRONJQVewhqAB5s1wi9YcXcJXHX2nZ/iNJQ= Received: by 10.52.110.7 with SMTP id hw7mr47967vdb.30.1302798779286; Thu, 14 Apr 2011 09:32:59 -0700 (PDT) MIME-Version: 1.0 Received: by 10.52.114.33 with HTTP; Thu, 14 Apr 2011 09:22:49 -0700 (PDT) In-Reply-To: References: <8B700116-AFCF-490E-9C6F-19F0A2F76D21@thelastpickle.com> <95CBEB64-BE37-4A7F-B14A-5C42C9973F99@thelastpickle.com> From: Jonathan Ellis Date: Thu, 14 Apr 2011 11:22:49 -0500 Message-ID: Subject: Re: Indexes on heterogeneous rows To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 On Thu, Apr 14, 2011 at 6:48 AM, David Boxenhorn wrote: > The reason why I put "type" first is that queries on type will > always be an exact match, whereas the other clauses might be inequalities. Expression order doesn't matter, but as you imply, non-equalities can't be used in an index lookup and have to be checked in a nested loop phase afterwards. -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com