Does a SQLite Foreign key automatically have an index?

In the SQLite Documentation it says:

… “an index should be created on the child key columns of each foreign key constraint”

ie. the index is not automatically created, but you should create one in every instance.