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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-17 : 11:33:02
|
Keith writes "Getting a SQL queries runnning is always a easy task, but gettign a l queries to compile fast and efficient is always a challenge to all programmerm especially to those web
programmers.
I have a question here on how to optimize/shorten then compile time of a joint table queries. I have joint 2 table with an identify key, and have "where" to set 3 contidion on what info that i want to retrive. for example,
select count(area1.areaid) as counting from area1, area
where area.adminid=1 and area1.areaid >80 and
area.areaid=area1.belongto
Unfortunately, everytime the quesries has been run the result will took up to 6-7 sec to get the specific outcome. Please tell me how write this queries efficiently to optimize/shorten the compilation time.
thank you!" |
|
|
|
|
|
SQL programming for optimization