Re: Build an index to join two CFs

2010-09-10 Thread Alvin UW
o the query is answered by one slice request to one CF, then you do not > need joins. > > If you want some advice on the data model, move the discussion to the user > list. > > Aaron > > > > On 11 Sep 2010, at 09:01, Alvin UW wrote: > > > Hello, > > >

Re: Build an index to join two CFs

2010-09-10 Thread aaron morton
going to build an index to join two CFs. > First, we see this index as a CF/SCF. The difference is I don't materialise > it. > Assume we have two tables: > ID_Address(*Id*, address) , Name_ID(*name*, id) > Then,the index is: Name_Address(*name*, address) > > When the ap

Build an index to join two CFs

2010-09-10 Thread Alvin UW
Hello, I am going to build an index to join two CFs. First, we see this index as a CF/SCF. The difference is I don't materialise it. Assume we have two tables: ID_Address(*Id*, address) , Name_ID(*name*, id) Then,the index is: Name_Address(*name*, address) When the application tries to que