Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vickyinrhyme
Starting Member
4 Posts |
 Posted - 2009-07-30 : 16:48:12
|
| I don't know if this is right place to ask this but i thought that someone can give insight on this.What is the process followed to estimate the time / days to write sql queries for requirements. How is the complexity of sql queries rated / calculated.Any idea? Anyone who have done estimation? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-07-30 : 18:49:38
|
| It depends on a number of factors:- Which data needs to be returned by the query- Internal or external processes that affect needed data (imports, job processing)- How that data is stored (number of tables, databases, columns, etc.)- Knowledge of database and skill level of person(s) creating the queriesThere could be other factors as well. Without detailed knowledge of the databases it's impossible to estimate accurately. |
 |
|
|
Vickyinrhyme
Starting Member
4 Posts |
Posted - 2009-08-04 : 13:56:07
|
| How is the complexity of SQL Queries are evaluated? Is there any standard method? like Simple Query (Simple Select and from one table) - 2, Complex (2 - 3 tables) - 6, More Complex (more than 3 tables) - 12. is there any kind of way to evaluate complexity of SQL Queries? Any help will be appreciated |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-08-04 : 20:37:31
|
| No, there isn't. It is entirely dependent on the factors I mentioned earlier. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Estimating time & Complexity of Sql Queries