Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oci9 performance

384969Jan 8 2003
performance problems with oci9 under Oracle 9i database.

All select statements which use an index are twice as slow under oci9 compared with oci.

Example :-

Table tab1, column col1 - no index

select * from tab1 where col1='X'

under oci and oci9 performance is similar.

If i add an index on "col1" (either unique or non-unique - no difference) then oci9 takes twice as long, does anyone have any idea why this is.

The database is unicode (CHARACTER SET "UTF8" NATIONAL CHARACTER SET "AL16UTF16").
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2003
Added on Jan 8 2003
#general-database-discussions
0 comments
255 views