> For the complete documentation index, see [llms.txt](https://docs.quizhour.mrb-lab.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quizhour.mrb-lab.com/admin/3.-firebase-setup/3.3-database-index-setup.md).

# 3.3 Database Index Setup

From the Firestore Database, Click on the **Indexes** tab and click on the **Add Index**. You have to create **three indexes** for the database.

> * Enter **questions** as Collection ID, **quiz\_id** into the first field and set **Ascending**, Enter **created\_at** in the second field and set **Ascending,** Enter **\_\_name\_\_**  in the third field and set **Ascending** and then select **Collection** as query scope and save it.
> * Enter **quizes** as Collection ID, **live\_quiz.is\_live** into the first field and set **Ascending**, Enter **live\_quiz.start\_at** in the second field and set **Ascending,** Enter **\_\_name\_\_**  in the third field and set **Ascending** and then select **Collection** as query scope and save it.
> * Enter **quiz\_comments** as Collection ID, **quiz\_id** into the first field and set **Ascending**, Enter **created\_at** in the second field and set **Descending,** Enter **\_\_name\_\_**  in the third field and set **Descending** and then select **Collection** as query scope and save it.

This may take 3-5 minutes to activate. After completing this, your index page should look like this:

<figure><img src="/files/zEjVqFResIzWmdjPRCB5" alt=""><figcaption></figcaption></figure>