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: