Hi frnds this question is asked at IBM One query is there when we dont collect

Hi frnds this question is asked at IBM
One query is there when we dont collect stastics on
it,exlapin will show us LOW CONFIDENCE,When we collect
stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL
ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012

THANKS IN ADVANCE

Question Posted / gowthami8.b

2 Answers
6379 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exl..

Answer / tdguy

statistics collection is a concept, where TD stores the
demographic data and stores. When generating the explain
plan, TD looks for the stats for the columns used in the
sql., particularly the columns used on both sides of the
join. TD prepares a estimate based on the data available.If
enough stats are not available, TD displays a low
confidence. Whereas, if stats are collected for columns
involved in sql, stats will be available for TD, which in
turn displays a high confidence, which means exact or close
approximate no of rows processed will be displayed.

Is This Answer Correct ?

6 Yes

0 No

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exl..

Answer / rkraju

when we collect stats the demographic information stored on
table header.so the optimizer picks the stats information
from the table header for generating plan for a given query.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer