[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Substr on SQL in SQR
- Subject: Re: [sqr-users] Substr on SQL in SQR
- From: "Christopher Wanko" <WankoC@wyeth.com>
- Date: Tue, 12 Nov 2002 12:58:31 -0500
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
>>> LRoux@syr.edu 11/01/02 07:30PM >>>
The reason this is happening is that you are forcing a tablescan - and if the
field is not the primary key you are digging a big hole.
3) better yet, us a double where clause (where field1 >= '1' and field1 < '2')
>>>
In the last example, wouldn't "where field1 = '1'" be fastest?
-Chris
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users