The 'employees with age = 35' scenario is exactly what they are useful for.
There's a quick section in the pycassa documentation that might be useful:
http://pycassa.github.com/pycassa/tutorial.html#indexes
On Mon, Nov 29, 2010 at 11:41 PM, Narendra Sharma wrote:
>
>
> On Mon, Nov 29, 2010 at
On Mon, Nov 29, 2010 at 9:32 PM, Jonathan Ellis wrote:
> On Mon, Nov 29, 2010 at 11:26 PM, Narendra Sharma
> wrote:
> > Thanks Jonathan.
> >
> > Couple of more questions:
> > 1. Is there any technical limit on the number of secondary indexes that
> can
> > be created?
>
> Just as with traditiona
On Mon, Nov 29, 2010 at 11:26 PM, Narendra Sharma
wrote:
> Thanks Jonathan.
>
> Couple of more questions:
> 1. Is there any technical limit on the number of secondary indexes that can
> be created?
Just as with traditional databases, the more indexes there are the
slower writes to that CF will be
Thanks Jonathan.
Couple of more questions:
1. Is there any technical limit on the number of secondary indexes that can
be created?
2. Is it possible to execute join queries spanning multiple secondary
indexes?
Thanks,
Naren
On Mon, Nov 29, 2010 at 6:02 PM, Jonathan Ellis wrote:
> On Mon, Nov
On Mon, Nov 29, 2010 at 7:59 PM, Narendra Sharma
wrote:
> Is there any documentation available on what is possible with secondary
> indexes?
Not yet.
> - Is it possible to define secondary index on columns within a SuperColumn?
No.
> - If I define a secondary index at run time, does Cassandra
