> For the complete documentation index, see [llms.txt](https://doc.newshour.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://doc.newshour.mrb-lab.com/admin-setup/3.-firebase-setup/3.3-database-index-setup.md).

# 3.3 Database Index Setup

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

> 1. Enter **articles** as Collection ID, **status** into the first field and set **Ascending**, Enter **views** 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.
> 2. Enter **articles** as Collection ID, **content\_type** into the first field and set **Ascending**, Enter **status** in the second field and set **Ascending,** Enter **created\_at**  in the third field and set **Descending,** Enter **\_\_name\_\_**  in the fourth field and set **Descending** and then select **Collection** as query scope and save it.
> 3. Enter **comments** as Collection ID, **article\_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.
> 4. Enter **articles** as Collection ID, **category.id** into the first field and set **Ascending**, Enter **status** in the second field and set **Ascending,** Enter **created\_at** in the third field and set **Descending,** Enter **\_\_name\_\_**  in the fourth field and set **Descending** and then select **Collection** as query scope and save it.
> 5. Enter **articles** as Collection ID, **status** 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.
> 6. Enter **articles** as Collection ID, **featured** into the first field and set **Ascending**, Enter **status** in the second field and set **Ascending,** Enter **views** in the third field and set **Descending,** Enter **\_\_name\_\_**  in the fourth field and set **Descending** and then select **Collection** as query scope and save it.
> 7. Enter **articles** as Collection ID, **content\_type** into the first field and set **Ascending**, Enter **status** in the second field and set **Ascending,** Enter **views** in the third field and set **Descending,** Enter **\_\_name\_\_**  in the fourth field and set **Descending** and then select **Collection** as query scope and save it.
> 8. Enter **comments** as Collection ID, **article\_author\_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:

<div align="left"><figure><img src="/files/4OpaTxX2zeBRrKVcgs5i" alt=""><figcaption></figcaption></figure></div>