Thanks for the reply vladimir but we can't upgrade c* binary that soon as we have a quick requirement for the use case I said in my first mail.
So just wanted to know the difference between the 2 queries I asked in my last mail 1. select * from ks1.cf1 where status=1; 2. select * from ks1.cf1 where id1=123456 and status=1; where id1 is partition key and status is indexed column as I said above. Could you please tell me the performance difference btwn above 2 queries. Thanks in advance, Techpyaasaa On Jun 25, 2017 11:29 PM, "Vladimir Yudovin" <vla...@winguzone.com> wrote: > Hi, > > beyond scope of your question (as you use 2.1.17) but starting from v3.4 SASI > is avaialble > <https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndexConcept.html>, > doc is about DSE, but is applicable for free version as well. > > Best regards, Vladimir Yudovin, > *Winguzone <https://winguzone.com?from=list> - Cloud Cassandra Hosting* > > > ---- On Mon, 19 Jun 2017 14:00:40 -0400 *techpyaasa . > <techpya...@gmail.com <techpya...@gmail.com>>* wrote ---- > > Hi, > > I want to create Index on already existing table which has more than 3 > GB/node. > We are using c*-2.1.17 with 2 DCs , each DC with 3 groups and each group > has 7 nodes.(Total 42 nodes in cluster) > > So is it ok to create Index on this table now or will it have any problem? > If its ok , how much time it would take for this process? > > > Thanks in advance, > TechPyaasa > > >
