Help with Join Index

Database
Enthusiast

Help with Join Index

I've created a Join Index on a table which the query is utilizing in DEV. Promoted the same to PROD and the query is not utilizing the Join Index and taking more time to complete. Please help on this issue.

Thanks,
Praneeth

2 REPLIES
Junior Supporter

Re: Help with Join Index

Three things come to my mind:

·Statistics (lack of).
·Data amount.
·Data distribution.

Cheers.

Carlos.
Enthusiast

Re: Help with Join Index

Statistics - Collected
Data Amount - Base Table - 338 million
Join Index - 85 million
Data Distribution - surrogate key