django的ORM中添加索引

可以直接在models中给某一个字段添加索引

class Book(models.Model):
    title = models.CharField(max_length=64, unique=True, help_text='书名')
    create_time = models.DateTimeField(default=datetime.now, editable=False, help_text='创作时间')
    description = models.TextField(max_length=64, help_text='描述')
    bookinfo = models.OneToOneField('BookInfo',on_delete=models.CASCADE, related_name='book')

    class Meta:
        db_table = 'book'
        verbose_name_plural = verbose_name = '书籍'
        indexes = [
            models.Index(fields=['title'])
        ]

现在我们查看一下有没有走索引

posted @ 2021-07-12 17:07  死里学  阅读(1427)  评论(0)    收藏  举报