Thank you for explanation.
Regards,
...michal


Ann W. Harrison wrote:

>Michal Rzewuski wrote:
>
>
>>Hello,
>>When will the engine start to use new index assuming the optimizer would
>>like to choose it?
>>
>>
>
>For inserts, updates, and deletes, the engine (all architectures) starts
>using the new index immediately. If that didn't happen, the index would
>become out of sync as soon as an update happened. Selects will also be
>re-optimized as soon as the index is created.
>
>Regards,
>
>
>Ann
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>