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 |
|
Renny2077
Starting Member
2 Posts |
 Posted - 2006-06-19 : 07:07:32
|
| Can anyone explain to mn the connection between a data access strategy and the time required for a query execution? How can a data access strategy improve query performance? |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-19 : 13:07:14
|
quote:
Can anyone explain to mn the connection between a data access strategy and the time required for a query execution? How can a data access strategy improve query performance?
You probably mean some tips on the data access programming (like specify the COLUMN LIST instead of using * to reduce network traffice since not all columns you will need). Or using a covered index rather than just SELECT *. You will find a lot of these tips in the forum and in the internet. Mastering them takes practice though (as with anything else) :).May the Almighty God bless us all! |
 |
|
|
Renny2077
Starting Member
2 Posts |
Posted - 2006-06-20 : 01:06:44
|
| I just needed some general understanding on data access strategy and its relationship to query execution. Couldn't find anything on the internet. Does a data access strategy only affect query performance by defining what kind of locks the query can initiate? Or is it more than that? |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-21 : 20:03:52
|
| Well, my understanding when you said "data access strategy" refers to the combination of techniques/tips/methods of how you formulate/implement your select (or other means of "accessing data") to speed up performance. However, you may also refer to the design that may cause sluggish performance (i.e. denormalization on an OLTP system). At anyrate, it is a vague and wide area to cover. If you need the general understanding, I can say as much as this, In a RDBMS system, Try to minimize as much as disk IO since it is the most expensive. Every performance tuning follows directly or indirectly to this principle.May the Almighty God bless us all! |
|
|
|
|
|
|
Data access strategy and query