Join index

Database
Enthusiast

Join index

Does Join index gets refreshed as data in either of the two tables gets refreshed?
1 REPLY
Enthusiast

Re: Join index

Join indexes are automatically maintained by the system when we do insert,update and delete operations on the tables on which the index is defined.

I think it will be shown in the execution plan (i am not sure about this, if you have time, pls check this and confirm)

also, join indexes cannot be used in Fastload and Multiload. You have to drop the index, do the operation and create in again.