appwrite/docs/references/tablesdb/create-index.md

Creates an index on the columns listed. Your index should include all the columns you will query in a single request. Type can be key, fulltext, or unique.