thanks for your quick reply. I have a query with sort on a non indexed column and it take a long time, and I have lot of memory on 2 cpus linux box. So, how to see on which support sorts are made (disk or memory) ?
If I can't influence a sort area inside DBMS server, how can I have better performance without index on this column ? Eric -----Message d'origine----- De : Zabach, Elke [mailto:[EMAIL PROTECTED] Envoy� : jeudi 19 juin 2003 15:21 � : 'EXT / MASTERLINE BRETAUD Eric'; '[EMAIL PROTECTED]' Objet : RE: how sapdb work with data sort ? EXT / MASTERLINE BRETAUD Eric wrote: > Does exist an equivalent parameter like than Oracle > parameter SORT_AREA_SIZE ? > > Or anything else on configuration parameter to influence sorts > (SELECT...DISTINCT, ORDER BY...) SAP DB handles sorts differently to Oracle. There is no special sort area used, therefore no configuration parameter needed to specify its size. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
