Sign in or 

|
rwhomer |
Chemistry Data Cartridges
Jan 15 2008, 6:47 PM EST
I have implemented 2 data cartridges and managed the development of a third one. The hard part is if you want to get the Optimizer to make useful choices. With chemistry cartridges at least many queries are highly selective and many more are very very unselective. Communicating this to Oracle isn't all that easy. And forget about using a version earlier than 10g. The 9i version always chose to use the domain index even if there was a much betteer access path. Its an interesting technology though and for some applications its the best way to integrate complex data with Oracle. 1 out of 2 found this valuable. Do you?
Keyword tags:
Application Programming
Data Cartridge
Domain Index
|