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