From oracle-l-bounce@freelists.org Wed May 5 09:12:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45EC5e15561 for ; Wed, 5 May 2004 09:12:15 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i45EBs615514 for ; Wed, 5 May 2004 09:12:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C14E972D06D; Wed, 5 May 2004 09:02:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31669-44; Wed, 5 May 2004 09:02:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2241572D071; Wed, 5 May 2004 09:02:43 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 09:01:29 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 863A372D039 for ; Wed, 5 May 2004 09:01:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30969-58 for ; Wed, 5 May 2004 09:01:29 -0500 (EST) Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id CB5D072D027 for ; Wed, 5 May 2004 09:01:28 -0500 (EST) Received: (qmail 5073 invoked from network); 5 May 2004 14:15:12 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 5 May 2004 14:15:12 -0000 Message-ID: <006801c432aa$d1bdea10$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: Subject: CONTAINS,CATSEARCH, andMATCHES are more effective than plsql equivalent? Date: Wed, 5 May 2004 10:11:00 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=Windows-1252 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4434 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi If you have installed Oracle text you can use other functions like CONTAINS,CATSEARCH, andMATCHES My question is if someone knows about some performance test that shows Oracle text functions as better than plsql equivalent functions. Thanks Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------