Welcome! This is a website that everyone can build together. It's easy!

Location: Data Cartridge

Discussion: Chemistry Data Cartridges

Keyword tags: Application Programming Data Cartridge Domain Index

Watch

Anonymous  (Get credit for your thread)
rwhomer

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?    

Sign in to be the first to reply.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Data Cartridge