25727d0f604cdf295c116beef0ad0ce47b5014a1
angie
  Wed Jan 10 14:40:42 2018 -0800
Added index on track field to hubSearchText.sql.  refs #20694 note-11

diff --git src/hg/lib/hubSearchText.sql src/hg/lib/hubSearchText.sql
index 61ac57d..1058f5b 100644
--- src/hg/lib/hubSearchText.sql
+++ src/hg/lib/hubSearchText.sql
@@ -1,17 +1,18 @@
 # hubSearchText.sql was originally generated by the autoSql program, which also 
 # generated hubSearchText.c and hubSearchText.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Track hub descriptions
 CREATE TABLE hubSearchText (
     hubUrl longblob,	# Hub URL
     db varchar(255),	# Assembly name (UCSC format) for Assembly and Track descriptions, NULL for hub descriptions
     track varchar(255),	# Track name for track descriptions, NULL for others
     label varchar(255),	# Name to display in search results
     textLength enum("Short", "Long"),	# Length of text (short for labels, long for description pages)
     text longtext,	# Description text
               #Indices
     KEY (textLength),
+    INDEX (track),
     FULLTEXT INDEX (text)
 );