[SQL] Estimation of SQL statements

2001-02-22 Thread Kevin Quinlan
Are there any good techniques that estimate the time it will take to execute an SQL statement, specifically an INSERT, SELECT, UPDATE, or DELETE? What factors are important to consider when estimating the execution time of these types of SQL statements? Thank you, Kevin

[SQL] Speed of SQL statements

2001-02-22 Thread Kevin Quinlan
Does anyone have any performance numbers regarding SQL statements, specifically SELECT, UPDATE, DELETE, and INSERT? For instance, on average how long does a typical SELECT (UPDATE, DELETE, INSERT) statement take to execute? Thank you, Kevin