Sqlite are foreign keys indexed?

[Yahya]

Hello, I would like to ask you a big problem to ask about this subject, sqlite are foreign keys indexed Thank you for giving me a hand as soon as possible by return message.

[Marco]

Yes, Foreign keys needing an index. Need someone more familiar with the design philosophy and source code than I am (which is not at all).