December 10, 2001 at 11:51 am
I use links to Oracle 8i from SQL2000 quite often. Recently the Oracle DBA added a "Function Index" on a column on a table I link to. I began to receive an "invalid schema definition" error message. The Oracle client I am using on the server is 2.00.03.01. Any suggestions?
December 10, 2001 at 11:58 am
Not sure what a "Function Index" is.
No real idea. Don't find anything on MSDN or Technet. Perhaps Oracle has some ideas?
Steve Jones
December 11, 2001 at 4:17 am
A function index is used to prevent a table scan on an indexed field. Let's say there is a field NAMES that is indexed. Using a RTRIM on that field in a query would force a table scan. You can set up a function index with the syntax RTRIM that would create a index based on that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply