on 11-12-2007 3:55 PM
We have 15 variables for one report the variables like created by agent id, created by agent level, created by agent subgroup,transaction number etc. they are arranged in the sequence like
1.created by agent id,
5. created by agent level,
7.created by agent subgroup,
10.transaction number
The similar variables we want to arrange in a sequence
1.created by agent id,
2. created by agent level,
3.created by agent subgroup,
10.transaction number
Would there be any impact on performance, would there would be any impact on select statements in the backend.
Hello Raj
The sequence of variable doesn't matter, the important is that you use that char in filter or some of them so that restricted data set is brought in query buffer.
Thanks
Tripple k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.