Hi, 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?! It only seems to help if we have all the fields were are selecting in a multi-field index. Many thanks, David _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
