usage of calculated index with a synonym for the function
Date: Mon, 14 Dec 2009 16:33:40 +0100
in a large table OUR_TABLE we have a calculated index for a persons-name
with a simple soundex function OUR_SOUNDEX in the same schema (OUR_SCHEMA)
like the table, thats different to my "select"-schema (WORK_SCHEMA):
from OUR_SCHEMA.OUR_TABLE d
where OUR_SCHEMA.OUR_SOUNDEX(d.PERSON_NAME) =
But for building a testing environment schema-names are different (OUR_SCHEMA --> TEST_SCHEMA, WORK_SCHEMA --> WORK_TEST) Now I'm trying to create universal scripts with synonyms:
CREATE OR REPLACE SYNONYM OUR_SCHEMA_OUR_SOUNDEX FOR OUR_SCHEMA.OUR_SOUNDEX; in WORK_TEST
CREATE OR REPLACE SYNONYM OUR_SCHEMA_OUR_SOUNDEX FOR TEST_SCHEMA.OUR_SOUNDEX; But
from OUR_SCHEMA_OUR_TABLE d
where OUR_SCHEMA_OUR_SOUNDEX(d.PERSON_NAME) =
uses a full table scan in WORK_SCHEMA and TEST_SCHEMA.
Is there another way to create universal scripts.
-- Norbert Oracle9i Enterprise Edition Release 11.2 64BitReceived on Mon Dec 14 2009 - 09:33:40 CST