Fetch wikipedia articles query optimization in mysql wikipedia Database

Fetch wikipedia articles query optimization in mysql wikipedia Database

I have imported the Wikipedia database to a local MySQL database and I wrote a query to fetch wiki pages.

My query is as follows :

SELECT
p.page_title,
p.page_id,
t.id,
text.old_text
FROM ...