Skip to Content
0
Former Member
Apr 23, 2009 at 07:45 PM

Query regarding single table optimizer

22 Views

Hello there,

It is mentioned on the wiki (regarding search area) that the search area is not bounded and a full table scan is performed if the predicate involves a non key( and non-indexed) attribute.

Explain output of various single table queries also show that the pagecount to is equal to total no. of pages for the entire table.

So can it be concluded that in such a scenario maxdb assumes the selectivity to be 100% ? i.e the single table optimizer does not consider selectivity of the predicate if its a non key (non-index) attribute?