Re: function based index in 9i require query_rewrite_enabled

  • From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
  • To: boris_dali@xxxxxxxx
  • Date: Fri, 10 Feb 2006 22:27:33 -0400

VGhhbmsgeW91LCB5aG91IGFyZSByaWdodCwgc2VyYWNoaW5nIG9uIDEwZywgdGhlcmUgaXMgbm90
aGluZyBhYm91dAp0aGUgcGFyYW1ldGVyLCBJIG1pc3MgdGhhdCBwb2ludCwgdmVyeSBpbnRlcmVz
dGluZwoKMTBncjIKUmVzdHJpY3Rpb25zIGZvciBGdW5jdGlvbi1CYXNlZCBJbmRleGVzCk5vdGUg
dGhlIGZvbGxvd2luZyByZXN0cmljdGlvbnMgZm9yIGZ1bmN0aW9uLWJhc2VkIGluZGV4ZXM6CpQg
T25seSBjb3N0LWJhc2VkIG9wdGltaXphdGlvbiBjYW4gdXNlIGZ1bmN0aW9uLWJhc2VkIGluZGV4
ZXMuIFJlbWVtYmVyIHRvIGNhbGwKREJNU19TVEFUUy5HQVRIRVJfVEFCTEVfU1RBVElTVElDUyBv
ciBEQk1TX1NUQVRTLkdBVEhFUl8KU0NIRU1BX1NUQVRJU1RJQ1MsIGZvciB0aGUgZnVuY3Rpb24t
YmFzZWQgaW5kZXggdG8gYmUgZWZmZWN0aXZlLgqUIEFueSB0b3AtbGV2ZWwgb3IgcGFja2FnZS1s
ZXZlbCBQTC9TUUwgZnVuY3Rpb25zIHRoYXQgYXJlIHVzZWQgaW4gdGhlIGluZGV4CmV4cHJlc3Np
b24gbXVzdCBiZSBkZWNsYXJlZCBhcyBERVRFUk1JTklTVElDLiBUaGF0IGlzLCB0aGV5IGFsd2F5
cyByZXR1cm4gdGhlCnNhbWUgcmVzdWx0IGdpdmVuIHRoZSBzYW1lIGlucHV0LCBmb3IgZXhhbXBs
ZSwgdGhlIFVQUEVSIGZ1bmN0aW9uLiBZb3UgbXVzdAplbnN1cmUgdGhhdCB0aGUgc3VicHJvZ3Jh
bSByZWFsbHkgaXMgZGV0ZXJtaW5pc3RpYywgYmVjYXVzZSBPcmFjbGUgRGF0YWJhc2UgZG9lcwpu
b3QgY2hlY2sgdGhhdCB0aGUgYXNzZXJ0aW9uIGlzIHRydWUuClRoZSBmb2xsb3dpbmcgc2VtYW50
aWMgcnVsZXMgZGVtb25zdHJhdGUgaG93IHRvIHVzZSB0aGUga2V5d29yZApERVRFUk1JTklTVElD
OgqUIFlvdSBjYW4gZGVjbGFyZSBhIHRvcCBsZXZlbCBzdWJwcm9ncmFtIGFzIERFVEVSTUlOSVNU
SUMuCpQgWW91IGNhbiBkZWNsYXJlIGEgUEFDS0FHRSBsZXZlbCBzdWJwcm9ncmFtIGFzIERFVEVS
TUlOSVNUSUMgaW4gdGhlClBBQ0tBR0Ugc3BlY2lmaWNhdGlvbiBidXQgbm90IGluIHRoZSBQQUNL
QUdFIEJPRFkuIEVycm9ycyBhcmUgcmFpc2VkIGlmCkRFVEVSTUlOSVNUSUMgaXMgdXNlZCBpbnNp
ZGUgYSBQQUNLQUdFIEJPRFkuCldoZW4gdG8gVXNlIEZ1bmN0aW9uLUJhc2VkIEluZGV4ZXMKVXNp
bmcgSW5kZXhlcyBpbiBBcHBsaWNhdGlvbiBEZXZlbG9wbWVudCA1LTkKlCBZb3UgY2FuIGRlY2xh
cmUgYSBwcml2YXRlIHN1YnByb2dyYW0gKGRlY2xhcmVkIGluc2lkZSBhbm90aGVyIHN1YnByb2dy
YW0gb3IKYSBQQUNLQUdFIEJPRFkpIGFzIERFVEVSTUlOSVNUSUMuCpQgQSBERVRFUk1JTklTVElD
IHN1YnByb2dyYW0gY2FuIGNhbGwgYW5vdGhlciBzdWJwcm9ncmFtIHdoZXRoZXIgdGhlCmNhbGxl
ZCBwcm9ncmFtIGlzIGRlY2xhcmVkIGFzIERFVEVSTUlOSVNUSUMgb3Igbm90LgqUIElmIHlvdSBj
aGFuZ2UgdGhlIHNlbWFudGljcyBvZiBhIERFVEVSTUlOSVNUSUMgZnVuY3Rpb24gYW5kIHJlY29t
cGlsZSBpdCwgdGhlbgpleGlzdGluZyBmdW5jdGlvbi1iYXNlZCBpbmRleGVzIGFuZCBtYXRlcmlh
bGl6ZWQgdmlld3MgcmVwb3J0IHJlc3VsdHMKZm9yIHRoZSBwcmlvcgp2ZXJzaW9uIG9mIHRoZSBm
dW5jdGlvbi4gVGh1cywgaWYgeW91IGNoYW5nZSB0aGUgc2VtYW50aWNzIG9mIGEKZnVuY3Rpb24s
IHlvdSBtdXN0Cm1hbnVhbGx5IHJlYnVpbGQgYW55IGRlcGVuZGVudCBmdW5jdGlvbi1iYXNlZCBp
bmRleGVzIGFuZCBtYXRlcmlhbGl6ZWQgdmlld3MuCpQgRXhwcmVzc2lvbnMgaW4gYSBmdW5jdGlv
bi1iYXNlZCBpbmRleCBjYW5ub3QgY29udGFpbiBhbnkgYWdncmVnYXRlCmZ1bmN0aW9ucy4gVGhl
CmV4cHJlc3Npb25zIHNob3VsZCByZWZlcmVuY2Ugb25seSBjb2x1bW5zIGluIGEgcm93IGluIHRo
ZSB0YWJsZS4KlCBZb3UgbXVzdCBhbmFseXplIHRoZSB0YWJsZSBvciBpbmRleCBiZWZvcmUgdGhl
IGluZGV4IGlzIHVzZWQuCpQgQml0bWFwIG9wdGltaXphdGlvbnMgY2Fubm90IHVzZSBkZXNjZW5k
aW5nIGluZGV4ZXMuCpQgRnVuY3Rpb24tYmFzZWQgaW5kZXhlcyBhcmUgbm90IHVzZWQgd2hlbiBP
Ui1leHBhbnNpb24gaXMgZG9uZS4KlCBUaGUgaW5kZXggZnVuY3Rpb24gY2Fubm90IGJlIG1hcmtl
ZCBOT1QgTlVMTC4gVG8gYXZvaWQgYSBmdWxsIHRhYmxlIHNjYW4sIHlvdQptdXN0IGVuc3VyZSB0
aGF0IHRoZSBxdWVyeSBjYW5ub3QgZmV0Y2ggbnVsbCB2YWx1ZXMuCpQgRnVuY3Rpb24tYmFzZWQg
aW5kZXhlcyBjYW5ub3QgdXNlIGV4cHJlc3Npb25zIHRoYXQgcmV0dXJuIFZBUkNIQVIyIG9yIFJB
VyBkYXRhCnR5cGVzIG9mIHVua25vd24gbGVuZ3RoIGZyb20gUEwvU1FMIGZ1bmN0aW9ucy4gQSB3
b3JrYXJvdW5kIGlzIHRvIGxpbWl0IHRoZQpzaXplIG9mIHRoZSBmdW5jdGlvbidzIG91dHB1dCBi
eSBpbmRleGluZyBhIHN1YnN0cmluZyBvZiBrbm93biBsZW5ndGg6Ci0tIElOSVRJQUxTKCkgbWln
aHQgcmV0dXJuIDEgbGV0dGVyLCAyIGxldHRlcnMsIDMgbGV0dGVycywgYW5kIHNvIG9uLgotLSBX
ZSBsaW1pdCB0aGUgcmV0dXJuIHZhbHVlIHRvIDEwIGNoYXJhY3RlcnMgZm9yIHB1cnBvc2VzIG9m
IHRoZSBpbmRleC4KQ1JFQVRFIElOREVYIGZ1bmNfc3Vic3RyX2luZGV4IE9OCmVtcF90YWIoc3Vi
c3RyKGluaXRpYWxzKGVuYW1lKSwxLDEwKTsKLS0gQ2FsbCBTVUJTVFIgYm90aCB3aGVuIGNyZWF0
aW5nIHRoZSBpbmRleCBhbmQgd2hlbiByZWZlcmVuY2luZwotLSB0aGUgZnVuY3Rpb24gaW4gcXVl
cmllcy4KU0VMRUNUIFNVQlNUUihpbml0aWFscyhlbmFtZSksMSwxMCkgRlJPTSBlbXBfdGFiOwpT
ZWUgQWxzbzogT3JhY2xlIERhdGFiYXNlIFNRTCBSZWZlcmVuY2UgZm9yIGFuIGFjY291bnQgb2Yg
Q1JFQVRFCkZVTkNUSU9OIHJlc3RyaWN0aW9ucwo=
--
//www.freelists.org/webpage/oracle-l


Other related posts: