METHOD AND SYSTEM FOR OPTIMIZING PERFORMANCE IN NON-RELATIONAL DATABASES

A method and system is provided that optimizes performance in non-relational databases. A method includes: sorting and categorizing a first set of columns within a view of the non-relational database; marking a second set of columns within the view as if the second set of columns were already sorted and categorized prior to actual sorting and categorizing of the second set of columns, the second set of columns including all columns exclusive of the first set of columns; sorting and categorizing at least one column of the second set of columns in response to performing a query on the at least one column; maintaining the first set of columns in a portion of cache; and maintaining the at least one column of the second set of columns in another portion of cache. In the method, the second set of columns is visible as collapsed data.