Are you saying that the field in the WHERE should come first? I guess that makes sense.
--- "Becker, Holger" <[EMAIL PROTECTED]> wrote: > J. Jeff Roberts wrote: > > > 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? > > You have to valuate the additional space for the index and the > overhead > to keep index actual. > I think one index is the better solution. > But be aware that field3 is the first index column. > > Best regards, > Holger > SAP Labs Berlin __________________________________ 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
