Improve performance without column index
I can not create index on my table column because it is a very big size table around 1TB
of data , it is updating daily . every day I have to query data from this table .
actually I have to run one join query with this big table and a small table.
small table column I have Index , but big table no index , even I create index for
this it will take too much time to create and rebuild.
so big table is full tablescan and small table indexed scan.
is there any other way to speed up the query other than creating index ?
or How to improve the performance of this query ?
Eg:- select * from big_table bt,
small_table st
where bt.id = st.id ;