Need some help understanding exactly what EXPLAIN QUERY PLAN is returning. I'm getting the following from the following. Can someone explain what the "order" "from" and "detail" should be telling me?
Thanks, John Elrick Fenestra Techologies Scenario 1: Info on: query07 Execution time: query07 0.000000 0.000000 0.000000 ( 0.000000) select distinct CONTEXTS.context_oid as context_oid from elements, sequences, questionnaires, manifests, surveys, CONTEXTS where contexts.context_name = 'RECORD_CFN' and elements.element_oid = CONTEXTS.element_oid and elements.element_name = 'root' and sequences.sequence_oid = CONTEXTS.sequence_oid and sequences.sequence_name = 'root' and questionnaires.questionnaire_oid = CONTEXTS.questionnaire_oid and questionnaires.questionnaire_name = '9000500003' and manifests.manifest_oid = CONTEXTS.manifest_oid and manifests.manifest_name = 'X002' and surveys.survey_oid = CONTEXTS.survey_oid and surveys.survey_name = 'census_2007' order from detail 0 2 TABLE questionnaires WITH INDEX questionnaire_form_oid_idx 1 5 TABLE CONTEXTS WITH INDEX context_questionnaire_oid_idx 2 0 TABLE elements USING PRIMARY KEY 3 1 TABLE sequences USING PRIMARY KEY 4 3 TABLE manifests USING PRIMARY KEY 5 4 TABLE surveys USING PRIMARY KEY Scenario 2: Info on: query07 Execution time: query07 0.641000 0.000000 0.641000 ( 0.641000) select distinct CONTEXTS.context_oid as context_oid from elements, sequences, questionnaires, manifests, surveys, CONTEXTS where contexts.context_name = 'RECORD_CFN' and elements.element_oid = CONTEXTS.element_oid and elements.element_name = 'root' and sequences.sequence_oid = CONTEXTS.sequence_oid and sequences.sequence_name = 'root' and questionnaires.questionnaire_oid = CONTEXTS.questionnaire_oid and questionnaires.questionnaire_name = '9000500003' and manifests.manifest_oid = CONTEXTS.manifest_oid and manifests.manifest_name = 'X002' and surveys.survey_oid = CONTEXTS.survey_oid and surveys.survey_name = 'census_2007' order from detail 0 0 TABLE elements WITH INDEX element_name_idx 1 1 TABLE sequences WITH INDEX sequence_name_idx 2 2 TABLE questionnaires WITH INDEX questionnaire_form_oid_idx 3 3 TABLE manifests WITH INDEX manifest_name_idx 4 4 TABLE surveys WITH INDEX survey_name_idx 5 5 TABLE CONTEXTS WITH INDEX context_idx _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
