On 16.09.08 13:22, "Chuck Hill" <[EMAIL PROTECTED]> wrote: >> Why? If there is a case insensitive index on that column it should be able >> to use it as it is just a begins with search. > > I don't think the optimizer will match the collation to the UPPER > functions in the query. So this will table scan. I did not see why a > table scan with a trailing wildcard would be more than a minute slower > than this.
File system caching? If the queries are executed one after the other. Joshua, how did you make the testing? >> As it will use the index. How is FrontBase than handling case >> sensitive >> searches (if they are needed)? > > Unless there is a need for case sensitive ones, I just make the column > collate case insensitively. Of course, you still want an index on > that column. Right, I remember. It's something set on the column, not on the index in FrontBase. cug _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
