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 Thanks Roberto De Vita [EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
