> I am finding some surprising results with indexing. > > If I have a select with several fields, and do a where id = > 1, and I only > have id indexed, it does not seem to help the query at all. > I would have > thought SAP would use the id index to avoid a table scan, and > just select > the fields from the rows where id=1. But this does not seem > to happen! > > Can anybody please explain why?!
Please post the table and index definition, the SQL statement and the EXPLAIN SQL output to the list. Otherwise one could only conjecture... Regards Christian -- #include <std_disclaimer.h> /* The opinions stated above are my own and not necessarily those of my employer. */ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
