Return-Path: 
 <user-return-18538-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
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 8D74067A8
	for <apmail-cassandra-user-archive@www.apache.org>;
 Fri,  8 Jul 2011 14:57:19 +0000 (UTC)
Received: (qmail 26733 invoked by uid 500); 8 Jul 2011 14:57:17 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 26711 invoked by uid 500); 8 Jul 2011 14:57:16 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 26703 invoked by uid 99); 8 Jul 2011 14:57:16 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Jul 2011 14:57:16 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [67.192.241.121] (HELO smtp121.dfw.emailsrvr.com)
 (67.192.241.121)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Jul 2011 14:57:11 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp22.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id 749B11700E5
	for <user@cassandra.apache.org>; Fri,  8 Jul 2011 10:56:49 -0400 (EDT)
X-Virus-Scanned: OK
Received: by smtp22.relay.dfw1a.emailsrvr.com (Authenticated sender:
 eevans-AT-racklabs.com) with ESMTPSA id 4CDA51703C8
	for <user@cassandra.apache.org>; Fri,  8 Jul 2011 10:56:49 -0400 (EDT)
Subject: Re: 'select * from <cf>' - FTS or Index
From: Eric Evans <eevans@rackspace.com>
To: user@cassandra.apache.org
In-Reply-To: 
 <CAGXoe2W1GrBQfu3tV1w96mXkO_UMKuf3SuT+6UQufd9p403ZuQ@mail.gmail.com>
References: 
	 <CAGXoe2W1GrBQfu3tV1w96mXkO_UMKuf3SuT+6UQufd9p403ZuQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Date: Fri, 08 Jul 2011 09:56:57 -0500
Message-ID: <1310137017.5719.31.camel@erebus.lan>
Mime-Version: 1.0
X-Mailer: Evolution 2.32.3 
Content-Transfer-Encoding: 7bit

On Thu, 2011-07-07 at 19:34 -0400, A J wrote:
> Does a 'select * from <cf>'  with no filter still use the primary
> index on the key or do a 'full table scan' ? 

It's the equivalent of a range slice with no starting or ending keys,
and no starting or ending columns.  Indexing cannot save you; This is an
expensive query.

-- 
Eric Evans
eevans@rackspace.com