ASSOCIATE STATISTICS and operators

From: Erik <no_at_spam.com>
Date: Wed, 3 Sep 2003 21:46:58 +0200
Message-ID: <bj5gi4$6u8$1@news.lth.se>

Hi!

How can I (in 8i) define costs for an operator? For a function, it can be done using ASSOCIATE STATISTICS WITH FUNCTIONS... but
when I try that with my operator, Oracle says that it doesn't exist.

I tried creating a function like
CREATE FUNCTION my_x(a IN NUMBER, b IN LONG) RETURN NUMBER AS

    rslt NUMBER;
BEGIN
    SELECT x(a, b) INTO rslt FROM dual;
    RETURN rslt;
END; Worked, but it is terribly slow.

This must be a problem that can be solved, but I don't know how.

Any suggestions?

Thanks in advance
/ Erik Received on Wed Sep 03 2003 - 14:46:58 CDT