Model index referenceLink para este cabeçalho

Index classes ease creating database indexes. They can be added using the Meta.indexes option. This document explains the API references of Index which includes the index options.

Index optionsLink para este cabeçalho

class Index(fields=[], name=None)Link para esta definição

Creates an index (B-Tree) in the database.

fieldsLink para este cabeçalho

Index.fieldsLink para esta definição

A list of the name of the fields on which the index is desired.

By default, indexes are created with an ascending order for each column. To define an index with a descending order for a column, add a hyphen before the field’s name.

For example Index(fields=['headline', '-pub_date']) would create SQL with (headline, pub_date DESC). Index ordering isn’t supported on MySQL. In that case, a descending index is created as a normal index.

nameLink para este cabeçalho

Index.nameLink para esta definição

The name of the index. If name isn’t provided Django will auto-generate a name. For compatibility with different databases, index names cannot be longer than 30 characters and shouldn’t start with a number (0-9) or underscore (_).