f6d6a3207ce87ba1bcb81965eb428225a160925b tdreszer Tue Jun 4 14:07:58 2013 -0700 Combined key may be better than separate keys on cache starved RR. Ref #10910. diff --git src/hg/lib/metaDb.sql src/hg/lib/metaDb.sql index be3c837..f617e4d 100644 --- src/hg/lib/metaDb.sql +++ src/hg/lib/metaDb.sql @@ -1,10 +1,9 @@ #This contains metadata for a table, file or other predeclared object type. CREATE TABLE metaDb ( obj varchar(255) not null, # Object name or ID. var varchar(255) not null, # Metadata variable name. val varchar(2048) not null, # Metadata value. #Indices PRIMARY KEY(obj,var), - INDEX varKey (var), - INDEX valKey (val(64)) + INDEX varKey (var,val(64)) );