Oracle query processing question

From: Victor Rosenberg <>
Date: Sun, 13 Apr 2008 13:43:40 -0700 (PDT)
Message-ID: <>

Hey guys
We have some third party UDT that can be stored in the table as one of the columns. These UDT objects are created using stored procedures and are compared using other stored procedure. There also some kind of index created for this UDT column.
Here's example of a query:

select objectid
from st_test a
where SP_Compare(a.shape, SP_PolyFromText('Some initialization string')) = 1;

Shape field is the stored UDT object and SP_PolyFromText creates the object using a string parameter.

Now the question is whether the SP_PolyFromText run for every row in the table, and whether the index is used, because the performance of this query for a table with more than 10K rows is catastrophic.

Thanks in advance.

Victor Received on Sun Apr 13 2008 - 15:43:40 CDT

Original text of this message