Temporary table instead of repeated joins

Поиск
Список
Период
Сортировка
Искать

Temporary table instead of repeated joins

От:
Chantal Ackermann <chantal.ackermann@web.de>
Дата:
hello all,

in my program I have to check for a certain combination of data before I 
make an insert. The check is a select statement with a join and a 
function call. Now, I wonder if I could gain performance if I would 
create a temporary view that contained this join and the function call 
and the other constraints. There will be frequent inserts into the 
underlying tables so I can't use a real cache that is only updated once 
in a while (say, a temporary table).

So would a select on the view be faster or is the view really just some 
shortcut for the programmer but the database behaviour actually stays 
the same?

Thanks for any hints
Chantal




FAQ