Re: Query Optimiser Question

I think soultion space is a algebraical notion: if you regard all the permissible intervals of all the relevant parameters as pieces of axes in a mutidimensional space, you've got the solution space: the space of all possible solutions. If you then define criteria specifying how the parameters are allowed to depend on each other, you limit yourself to a part of the total solution space. The criteria an optimizer uses determines how big this reduction of the solution space will be.

Jaap.

Paul <paul_at_yeahright.com> schreef in artikel <Lk9X4.112$5Y.2956_at_news11-gui.server.ntli.net>...
> I have a question sitting here infront of me :
>
> Describe how cost based query optimisers work and include an explanation
 as
> to how they reduce the solution space and what aspects are compared by
 the
> optimiser.
>
> Its just the solution space i am abit puzzled by. Does this refer to the
> amount of space taken up by solution strategies in the DBMS? If so how
 does
> taking up large amounts of so called solution space lead to problems?
>
> Thanx
> Paul
>
>
>
  Received on Thu May 25 2000 - 00:00:00 CDT