Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: function based index in 9i require query_rewrite_enabled

Re: function based index in 9i require query_rewrite_enabled

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Fri, 10 Feb 2006 22:27:33 -0400
Message-ID: <cd4305c10602101827x41a82421gd2a7c4144f6bab53@mail.gmail.com>


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=

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 10 2006 - 20:27:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US