Advanced Configurations: Vindex

How do I make a CreateLookupVindex?
In addition to the user guide on CreateLookupVindex we also have an example walkthrough here.  This walkthrough demonstrates the syntax of a CreateLooku...
Thu, Dec 10, 2020 at 11:19 AM
What is a LookupVindex and how does it work?
CreateLookupVindex is a new VReplication workflow that was introduced in Vitess 6. It is used to create and backfill a lookup Vindex automatically for a tab...
Thu, Dec 10, 2020 at 11:18 AM
What is a secondary Vindex? How does it work?
Secondary Vindexes are additional Vindexes against other columns of a table offering optimizations for WHERE clauses that do not use the Primary Vindex. Sec...
Fri, Dec 18, 2020 at 10:59 AM
Does the Primary Vindex need to match its Primary Key?
It is not necessary that a Primary Vindex be the same as the Primary Key. In fact, there are many use cases where you would not want this. For example, if t...
Fri, Dec 18, 2020 at 11:00 AM
How do I create a unique index for a column in Vitess?
Unique index is a distinct MySQL option. For Vitess just normal MySQL DDL will do. You have a couple other options as well either to use `ApplySchema` or di...
Thu, Dec 17, 2020 at 11:17 AM