Oracle query processing question
Date: Sun, 13 Apr 2008 13:43:40 -0700 (PDT)
Message-ID: <3b8f60f0-9440-4f3c-a03d-3b88c86b65f6@b64g2000hsa.googlegroups.com>
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