Build an index to join two CFs

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

Re: Build an index to join two CFs

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