Collect Stats on Join Index.

Tools
Enthusiast

Collect Stats on Join Index.

1.) Can we do Collect Stats on Join Index.? If Yes Then please tell how can we...
1 REPLY
Enthusiast

Re: Collect Stats on Join Index.

Yes.
--Collecting stats on column f1 of ji:
collect stats on test.ji column f1;

--Collecting stats on ji:
collect stats on test.ji;