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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy