Consider the following performance
For example, using ToText ( ) to convert a numeric field to a string.
Note: Server will respond faster if you use indexed fields.
For example, a record selection of {@ExtendedPrice > 1000} where @ExtendedPrice = (Orders x Quantity) can't be pushed down. However, if @ExtendedPrice is replaced with a SQL Expression field it will be pushed down.
Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com |