I have two tables tableA and TableB.In TableA contains 3 columns(composite PI) and TableB contains 2 columns(composite PI).
But i am using 2 columns in join condition from both tables.I have query that collecting stats on combination of columns is best or
collecting stats on single column in each time is best?or we have to collect stats combination of columns and single column on each time is best?
could anyone Please clarify my doubt.Please explain clearly.
Thanks in advance.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.