April 6, 2010 at 7:24 am
GSquared (4/6/2010)
Nope. Just felt like chiming in on it anyway.
Fair enough 🙂
April 6, 2010 at 10:23 pm
At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.
At least they(ORACLE corp) can have the knowledge of RDBMS. they didn't maintain the FK constrain. Please check the orcale corp documentation that why we should nt use the FK constrain. It will always hinder the performance.
April 6, 2010 at 11:22 pm
sumit.joshij (4/6/2010)
At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.At least they(ORACLE corp) can have the knowledge of RDBMS. they didn't maintain the FK constrain. Please check the orcale corp documentation that why we should nt use the FK constrain. It will always hinder the performance.
Interesting, I find plenty of documentation for Oracle that contradicts that statement.
It is a very strong term to say something is "always" a certain way.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2010 at 2:20 am
Please see the oracle / oracle apps data base structure for the same where you can find that these people didnt find any FK relation.
April 7, 2010 at 2:22 am
sumit.joshij (4/7/2010)
Please see the oracle / oracle apps data base structure for the same where you can find that these people didnt find any FK relation.
Do you have a link? I am interested.
April 7, 2010 at 2:39 am
Please check the oracle database structure or consult the oracle DBA.
I have already check in the database the confirm with oracle DBA.
April 7, 2010 at 2:44 am
sumit.joshij (4/7/2010)
Please check the oracle database structure or consult the oracle DBA. I have already check in the database the confirm with oracle DBA.
I'm not that interested - just wondered if you had a handy link that's all.
I don't have an Oracle DBA to ask either.
Guess I'll just have to take your word for it then...? :blink:
April 7, 2010 at 6:08 am
sumit.joshij (4/6/2010)
At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.At least they(ORACLE corp) can have the knowledge of RDBMS. they didn't maintain the FK constrain. Please check the orcale corp documentation that why we should nt use the FK constrain. It will always hinder the performance.
As my first boss used to say... "there is nothing more dangerous than a little knowledge" and as Paul points it out the word "always" you used in a related post is a little too much. This is totally out of context.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 7, 2010 at 6:17 am
PaulB-TheOneAndOnly (4/7/2010)
...and as Paul points it out the word "always" you used in a related post is a little too much. This is totally out of context.
That was Jason, but I would probably have said it if he hadn't 🙂
April 7, 2010 at 7:43 am
sumit.joshij (4/6/2010)
At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.At least they(ORACLE corp) can have the knowledge of RDBMS. they didn't maintain the FK constrain. Please check the orcale corp documentation that why we should nt use the FK constrain. It will always hinder the performance.
Per AskTom, which is one of Oracle's primary sources of information for DBAs about the Oracle database engine, not only should you have foreign keys, but you should index them in most cases.
This is as of 5 months ago. I don't see any information leading me to believe this has changed.
So, essentially, your Oracle DBA was misinformed, per Oracle.
Bing/Google "Oracle foreign key". You'll get a lot of advice and data about how to create and use them, and I didn't see a single piece of data saying "don't use them" in the first 3 pages of results (which is as far as I looked). Thus, I have to conclude that the DBA you consulted with is most likely incorrect on that point.
If you can actually back this assertion up, or get your DBA to do so, with a valid reference, that's different. Till then, I'll consider it false information.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 7, 2010 at 9:48 am
GSquared (4/7/2010)
sumit.joshij (4/6/2010)
At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.At least they(ORACLE corp) can have the knowledge of RDBMS. they didn't maintain the FK constrain. Please check the orcale corp documentation that why we should nt use the FK constrain. It will always hinder the performance.
Per AskTom, which is one of Oracle's primary sources of information for DBAs about the Oracle database engine, not only should you have foreign keys, but you should index them in most cases.
This is as of 5 months ago. I don't see any information leading me to believe this has changed.
So, essentially, your Oracle DBA was misinformed, per Oracle.
Bing/Google "Oracle foreign key". You'll get a lot of advice and data about how to create and use them, and I didn't see a single piece of data saying "don't use them" in the first 3 pages of results (which is as far as I looked). Thus, I have to conclude that the DBA you consulted with is most likely incorrect on that point.
If you can actually back this assertion up, or get your DBA to do so, with a valid reference, that's different. Till then, I'll consider it false information.
This is the same thing I did. I too found nothing to back up this assertion. Thus having a link or some sort of documentation, I would have to take the same stance as Gus.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 11 posts - 61 through 70 (of 70 total)
You must be logged in to reply to this topic. Login to reply