问提高查询效率

EN

Select distinct A.LINK_ID as LINK_ID,
                B.POI_ID
from RDF_LINK as A,
     RDF_POI as B,
     RDF_POI_ADDRESS as c,
     RDF_LOCATION as d,
     RDF_ROAD_LINK as e,
     RDF_NAV_LINK as f
where B.[CAT_ID] = '5800'
  AND B.[POI_ID] = c.[POI_ID]
  AND c.[LOCATION_ID] = d.[LOCATION_ID]
  AND d.[LINK_ID] = A.[LINK_ID]
  AND A.[LINK_ID] = e.[LINK_ID]
  AND A.[LINK_ID] = f.[LINK_ID]

0   0   3   SCAN TABLE RDF_LOCATION AS d (~101198 rows)
0   1   0   SEARCH TABLE RDF_LINK AS A USING COVERING INDEX sqlite_autoindex_RDF_LINK_1 (LINK_ID=?) (~1 rows)
0   2   5   SEARCH TABLE RDF_NAV_LINK AS f USING COVERING INDEX sqlite_autoindex_RDF_NAV_LINK_1 (LINK_ID=?) (~1 rows)
0   3   4   SEARCH TABLE RDF_ROAD_LINK AS e USING COVERING INDEX NX_RDFROADLINK_LINKID (LINK_ID=?) (~2 rows)
0   4   1   SEARCH TABLE RDF_POI AS B USING AUTOMATIC COVERING INDEX (CAT_ID=?) (~7 rows)
0   5   2   SEARCH TABLE RDF_POI_ADDRESS AS c USING COVERING INDEX sqlite_autoindex_RDF_POI_ADDRESS_1 (POI_ID=? AND LOCATION_ID=?) (~1 rows)
0   0   0   USE TEMP B-TREE FOR DISTINCT