Your assumption is that all fields are not required in the default search query. In our case, joining 6 tables with 14 fields each is going to be much slower t

Your assumption is that all fields are not required in the default search query. In our case, joining 6 tables with 14 fields each is going to be much slower than running the query of just the table.