Menu
▾
▴
Re: [Flamerobin-devel] Another one: PLAN
|
From: Kjell R. <kje...@ad...> - 2006-02-28 06:59:08
|
Kjell Rilbe wrote: > Milan Babuskov wrote: > >> Kjell Rilbe wrote: >> >>> Oh, and it seems like FlameRobin doesn't allow me to specify a plan >>> for my select. It should, shouldn't it? >> >> I have no idea. How is it supposed to be done? > > SELECT ... > FROM ... > WHERE ... > ... > PLAN (TheTable NATURAL) > > (For example.) By the way, the purpose of being able to do this is to try out different plans to determine which one gives best performance and then drop/create indices accordingly, so that the best plan is chosen automatically. This can be done with all potentially useful indices present. Without it, I have to make the query optimizer choose various plan by dropping/creating indices to get all potentially useful combos. That's a lot more work than to simply create all the indices, try the various plans, then drop the indices that proved not to be useful. Kjell -- -------------------------------------- Kjell Rilbe Adressmarknaden AM AB E-post: kje...@ad... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |