if they already implement ARCSDE, you might want to look into performance tunning of SDE: there is a white paper of how to tune SDE. also, below is the script to analyze SDE table and indexes. Don't just analyze tables and index like you did in Oracle:

declare

CURSOR owner_cur IS

SELECT DISTINCT(OWNER) OWNER from SDE.LAYERS ORDER BY OWNER;



CURSOR index_cur IS

SELECT owner, index_name FROM dba_indexes

WHERE owner in (select distinct(owner) from sde.layers) and INDEX_TYPE = 'NORMAL'

ORDER BY owner, index_name;



SQL_STMT VARCHAR2(200);



begin

-- dbms_output.enable (100000);

-- dbms_output.put_line ('Starting SDE tuning procedure...');



FOR IndexRec in index_cur LOOP

SQL_STMT := 'alter index ' || IndexRec.owner || '.' || IndexRec.index_name || ' rebuild';

-- dbms_output.put_line (SQL_STMT);

EXECUTE IMMEDIATE SQL_STMT;

END LOOP;



FOR OwnerRec in owner_cur LOOP

-- dbms_output.put_line ('Analyzing schema: ' || OwnerRec.owner);

dbms_utility.analyze_schema (OwnerRec.owner, 'DELETE');

dbms_utility.analyze_schema (OwnerRec.owner, 'ESTIMATE');

END LOOP;





end;



/