EXT / MASTERLINE BRETAUD Eric wrote: > 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) ?
Neither nor sorting is done. Sorting is done during insert of a resultrecord into the resultset (if the resultset is physically build). > If I can't influence a sort area inside DBMS server, > how can I have better performance without index on > this column ? Increase the data-case. (installation-parameter CACHE_SIZE) the more pages can be hold in main memory, the better chance you have to find the page the new resultrecord to be included in the resultset wants to be inserted in, is in main memory and not on disk. Elke SAP Labs Berlin > > 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
