code: @Override
     protected void prepareQueries() throws SQLException
     {
        super.prepareQueries();
  
        FIND_NODE_MAIN_PROPERTIES_BY_PARENTID_CQ =
           FIND_NODE_MAIN_PROPERTIES_BY_PARENTID_CQ.replace("from " + JCR_ITEM + " I, " + JCR_VALUE + " V", "from "
              + JCR_ITEM + " I force index (" + JCR_IDX_ITEM_PARENT_NAME + "),  " + JCR_VALUE + " V force index ("
              + JCR_IDX_VALUE_PROPERTY + ")");
  
        FIND_NODES_AND_PROPERTIES =
           FIND_NODES_AND_PROPERTIES.replace("from " + JCR_ITEM + " I", "from " + JCR_ITEM + " I force index (PRIMARY)");
  
        FIND_ITEM_BY_NAME = "select * from " + JCR_ITEM + " where PARENT_ID=? and NAME=? and I_INDEX=? order by I_CLASS";
  
        if (containerConfig.useSequenceForOrderNumber)
        {
           FIND_LAST_ORDER_NUMBER = "SELECT " + JCR_ITEM_NEXT_VAL + "('LAST_N_ORDER_NUM', ?, ?) as nextVal";
        }
  
        FIND_NODES_BY_PARENTID_CQ =
           FIND_NODES_BY_PARENTID_CQ.replace("from " + JCR_ITEM + " I, " + JCR_ITEM + " P, " + JCR_VALUE + " V", "from "
              + JCR_ITEM + " I force index (" + JCR_IDX_ITEM_N_ORDER_NUM + "), " + JCR_ITEM + " P force index("
              + JCR_IDX_ITEM_PARENT_NAME + "), " + JCR_VALUE + " V force index (" + JCR_IDX_VALUE_PROPERTY + ")");
     }
docs: {@inheritDoc}