All Forums General
Purushotham 87 posts Joined 04/14
28 Oct 2014
what are the drawbacks by using join index table?
Purushotham.M
Raja_KT 1246 posts Joined 07/09
28 Oct 2014

You could have read the doc :)
 

Join indexes can be expensive to maintain. 

Each time a join-indexed base table column is updated or deleted, the corresponding join index table column must also be updated or deleted. Each time a new row is added to a join-indexed base table, the corresponding join index table columns must also be inserted as a new join index subtable row.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

TD_Raj 50 posts Joined 05/10
17 Nov 2014

You cannot force TD to use Join index in your query.
So the situation may be you have created join index however your query may not use it.

You must sign in to leave a comment.