Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

There's nothing stopping you indexing multiple columns with different dictionaries either :). And indexing works beautifully with multiple weighted columns.

The related records point is true though - indexes don't help if you're trying to implement multi-table search. Although then I'd argue a materialized view (refreshed with triggers) might be better than putting more columns into one of the data tables.



I will have to tinker with that then...




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: