All Forums Database
Tinku 5 posts Joined 06/10
17 Aug 2010
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

CarlosAL 512 posts Joined 04/08
17 Aug 2010

Three things come to my mind:

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

Cheers.

Carlos.

Tinku 5 posts Joined 06/10
18 Aug 2010

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

You must sign in to leave a comment.