SQL Index builds

["Sean Courtney" <scourtney@xxxxxxxxxxx>]

Hello everyone,

 

maybe someone else also had similar issues.

 

Sometimes when I join tables in SQL a temporary index is built during
runtime.

 

I tried to counteract this by adding new LF?s and indexes ?  sometimes it
works and sometimes it doesn?t?

 

Is there a way to find out how sql builds these indexes ??   

 

If yes could someone please give we a quick update on how to find the index
definition.   If I were to create these indexes permanently then I would
probably 

Improve runtime performance considerably .. 

 

 

 

Mit freundlichen Grüßen / Kind regards / Bien à vous,

 

Sean