RE: strategies for optimizing 'like' operations
Date: Tue, 11 Mar 2008 08:30:50 -0500
Message-ID: <7070047601C21A4CB387D50AD3661F6E093E89CB@050EXCHANGE.research.na.admworld.com>
QWhoIEkgZmVlbCBiZXR0ZXIga25vdyBJJ20gbm90IHRoZSBvbmx5IG9uZSB0aGF0IHdhc24ndCBh
d2FyZSB5b3UgY291bGQgZG8gdGhpcy4gOikNCg0KQXMgZXhwbGFpbmVkIHRvIG1lIGJ5IGFub3Ro
ZXIgbWVtYmVyIG9mIHRoaXMgbGlzdDoNCg0KQWRkaW5nIHRoZSByb3dudW0gcHNldWRvIGNvbHVt
biBpbiBhIHN1YnF1ZXJ5IHByZXZlbnRzIHRoZSBvcHRpbWl6ZXIgZnJvbSBtZXJnaW5nIHRoZSBz
dWJxdWVyeSBpbnRvIHRoZSBwYXJlbnQgYmxvY2suICBTb21ldGltZXMgeW91IGtub3cgaG93IHRv
IGV4ZWN1dGUgdGhlIHNxbCBiZXR0ZXIgdGhhbiB0aGUgb3B0aW1pemVyIChmb3Igd2hhdGV2ZXIg
cmVhc29uKS4NCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogT3huYXJkIE1v
bnRhbHZvIFttYWlsdG86b3huYXJkQGNhcm9saW5hLnJyLmNvbV0gDQpTZW50OiBUdWVzZGF5LCBN
YXJjaCAxMSwgMjAwOCA4OjE4IEFNDQpUbzogU3RlcGhlbnMsIENocmlzDQpDYzogb3JhY2xlLWxA
ZnJlZWxpc3RzLm9yZw0KU3ViamVjdDogUkU6IHN0cmF0ZWdpZXMgZm9yIG9wdGltaXppbmcgJ2xp
a2UnIG9wZXJhdGlvbnMNCg0Kd2hhdCB0cmljayBpcyB0aGF0Pw0KDQpDT05GSURFTlRJQUxJVFkg
Tk9USUNFOiANCglUaGlzIG1lc3NhZ2UgaXMgaW50ZW5kZWQgZm9yIHRoZSB1c2Ugb2YgdGhlIGlu
ZGl2aWR1YWwgb3IgZW50aXR5IHRvIHdoaWNoIGl0IGlzIGFkZHJlc3NlZCBhbmQgbWF5IGNvbnRh
aW4gaW5mb3JtYXRpb24gdGhhdCBpcyBwcml2aWxlZ2VkLA0KY29uZmlkZW50aWFsIGFuZCBleGVt
cHQgZnJvbSBkaXNjbG9zdXJlIHVuZGVyIGFwcGxpY2FibGUgbGF3LiAgSWYgdGhlIHJlYWRlciBv
ZiB0aGlzIG1lc3NhZ2UgaXMgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgb3IgdGhlIGVtcGxv
eWVlIG9yIGFnZW50IHJlc3BvbnNpYmxlIGZvciBkZWxpdmVyaW5nIHRoaXMgbWVzc2FnZSB0byB0
aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IGFueSBk
aXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24gb3IgY29weWluZyBvZiB0aGlzIGNvbW11bmljYXRp
b24gaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMNCmNv
bW11bmljYXRpb24gaW4gZXJyb3IsIHBsZWFzZSBub3RpZnkgdXMgaW1tZWRpYXRlbHkgYnkgZW1h
aWwgcmVwbHkuDQo=
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 11 2008 - 08:30:50 CDT