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_SITEM I, JCR_SVALUE V",
                 "from JCR_SITEM I force index (JCR_IDX_SITEM_PARENT_NAME), JCR_SVALUE V force index (JCR_IDX_SVALUE_PROPERTY)");
  
        FIND_NODES_AND_PROPERTIES =
           FIND_NODES_AND_PROPERTIES.replace("from JCR_SITEM I", "from JCR_SITEM I force index (PRIMARY)");
  
        FIND_ITEM_BY_NAME =
           "select * from JCR_SITEM" + " where CONTAINER_NAME=? and 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_SITEM I, JCR_SITEM P, JCR_SVALUE V", "from JCR_SITEM I force index ("
              + JCR_IDX_ITEM_N_ORDER_NUM + "), JCR_SITEM P force index (" + JCR_IDX_ITEM_PARENT_NAME
              + "), JCR_SVALUE V force index (" + JCR_IDX_VALUE_PROPERTY + ")");
     }
docs: {@inheritDoc}