Support the Vector Index

[zimulala]

Feature Request

Is your feature request related to a problem? Please describe:

This issue plans to support the same processing of vector indexes as ordinary indexes, its specific functions are as follows :

• Support adding and using vector indexes, including adding vector indexes during and after table creation.
• Support dropping and renaming vector indexes.

Describe the feature you'd like:

• Proposal: support vector index #55706
• Support add vector index at the parser #55694
• Support for adding/dropping vector index after table creation in TiDB #55840
• Support for adding/dropping vector index during table creation in TiDB #56122
  • Support for Rename Vector Index
• Support for search with Vector Index
  • Update ANNQueryInfo in tipb: *: Add index_id to ANNQueryInfo to support multiple indexes on the same column tipb#339
  • Support to choose vector index by CBO and USE INDEX hint #56510
• Cherry-pick to master: *: support the vector index #56409
• Make HNSW the default type for the vector index #56428

Issues

• It is not appropriate to add names generated by anonymous vector indexes when creating tables. #56491
• create table with vector index does not support gbk charset

[JaySon-Huang]

Link to the vector search feature: #54245