Make a separate search table which form indexes with others related tables. Fire your query direct to this table and make join with others table by the help of result you get from this.