I am having one table with 4 columns. I that one is primary key and other three columns are references to columns of other tables. I am using join of these four tables for search filter. These joins are taking time.
So I was thinking to have indexes on columns. Because I read that make indexes on column of join condition. My question is will there be problem if all columns of table are indexed? Or any other way to decrease time complexity of these search filter. Thanks in advance.
- Table1(main search)-1000 entries primary_key fk1 fk2 fk3
- Table2-800 entries pk1 ..(8-9 columns)
- Table3-700 entries pk2 ..(10-12 columns)
- Table2-850 entries pk3 ..(7-8 columns)
I am using MyISAM engine.