Hello all,

I am using Cassandra version 2.0.7.  I am wondering if "collections" is
efficient for filtering.  We are thinking of using "collections" to
maintain a list for a customer row but we have to be able to filter on the
collection values.

Select UUID from customer where eligibility_state IN (CA, NC)

Eligibility_state being a collection.  The above query would be used
frequently.
Would you recommend collections for modeling from a performance perspective?

Raj
-- 

Data Architect ❘ Zephyr Health
589 Howard St. ❘ San Francisco, CA 94105
m: +1 9176477433 ❘ f: +1 415 520-9288
o: +1 415 529-7649 | s: raj.janakarajan

http://www.zephyrhealth.com

Reply via email to