Roberto De Vita wrote: > I have a table with 845.963 records on it, and I have to do a SELECT > DISTINCT query over just a field of it, but the results are wrong, it > brings me things from other fields, (�?). If i dont apply the DISTINCT > clause the results are fine. Also, it may be related or not, > but when i try > to get the results of a view defined over that table it > complains with an > error of something like not having enough space for temporal results, > > All this doesn't happens when i reduce the length of the > table to 700.000 > records, so it seems there's a threashold that stops me from > getting the > right results, I tried to apply indexes to that field to > avoid table scans, > and the results are poorer, My database kernel is 7.4.3 BUild > 014-120-037-952 and I'm running it on a Windows 2000 > profesional sp3, using > the SQLStudio 7.4 > I can send you further information if needed, but i really > need some light > on this
Could you please provide the table and index definition and the explain output of both statements with and without index. An example of the wrong output may also be helpful. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
