Help with Join Index

Database
N/A

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

Re: Help with Join Index

Three things come to my mind:

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

Cheers.

Carlos.
N/A

Re: Help with Join Index

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