Can u tell from the below Collect Stats , if both are same? If both are same which would be faster and which is advisable to be used
COLLECT STATISTICS ON SAMPLE INDEX FACTOR_ID;
My table looks like below.
it's not the same as the first COLLECT will fail without brackets around FACTOR_ID :-)
Otherwise both are processed exactly the same, simply check Explain.