1. A method for supporting multiple value attributes in a database system comprising the steps of: a) defining an index class by designating a plurality of attributes associated with the index class, wherein the plurality of attributes includes single value attributes and at least one multivalue attribute; b) generating an attribute value table (AVT) for the index class for storing attribute values for the single value attributes; and c) generating a multiple value table (MVT) for each of the at least one multivalue attribute for storing attribute values for the at least one multivalue attribute.