Thanks for the reply. I have a question about indices. If I typically do this:
select field1, field2 from table where field3 = 1 but I sometimes do this: select field1 from table where field3 = 1 then the first query benefits if I have an index that includes all 3 fields. Is there any reason to have an additional index on JUST field1 and field3 for the second query? It seems like it might be quicker to scan the smaller index, but would it make enough of a difference to offset the space I'd need for the separate index? -Jeff __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
