performance related problem


[ ruban.de ] [ Antworten ] [ Forum ]

Geschrieben von judi am April 30, 2003 um 17:29:

If I have a table with say 2 million rows with 7 indexes on it(mostly used table)
My question will there be any performance related problems if I construct a simple trigger which will work for every insertion and deletion on the base table a new row(with some of the data from base table) to be created on a sub table or deleted from the subtable
I think there will be an impact but i dont know in what percentage it can be..., can any body help me in this case


Antworten:


Schreibe eine Antwort

Name:   
E-Mail:  

Thema:

Kommentar:

Optionale Link URL:   
Link Titel:                  
Optionale Image URL:


[ Antworten ] [ Forum ]