I believe the expression can be removed even from your example query. The query must be able to pick out the position item in question. The query plan should have a positional variable added by default to the query plan. Could you post the query plan before and after optimization?
- Implementation of [ ] Shivani Mall
- Re: Implementation of [ ] Eldon Carman
- Re: Implementation of [ ] Shivani Mall
- Re: Implementation of [ ] Eldon Carman
- Re: Implementation of [ ] Shivani Mall
- Re: Implementation of [ ] Shivani Mall
- Re: Implementation of [ ] Shivani Mall
