如何理解这句话,没有看明白是什么意思

[复制链接]
查看11 | 回复4 | 2010-10-8 09:31:21 | 显示全部楼层 |阅读模式
You do not join from the parent table to the child table, or more generally the foreign key columns do not support an important access path to the child table and you do not use them in predicates to select data from this table (such as DEPT to EMP).
回复

使用道具 举报

千问 | 2010-10-8 09:31:21 | 显示全部楼层
不要单独拿出一句话来问大家,最好能有上下文和出处,这样大家也好能很好的理解,并能给你一个准确的解释。
回复

使用道具 举报

千问 | 2010-10-8 09:31:21 | 显示全部楼层
哈哈
回复

使用道具 举报

千问 | 2010-10-8 09:31:21 | 显示全部楼层
You do not join from the parent table to the child table, or more generally the foreign key columns do not support an important access path to the child table and you do not use them in predicates to select data from this table (such as DEPT to EMP).
大概意思是你不能通过父表向子表中插入数据,也就是说外键不支持。
比如说在dept表中只有10,20,30和40部门,那你在插入emp表的deptno列的时候不能超出这几个值。大概大概就这个意思吧。
回复

使用道具 举报

千问 | 2010-10-8 09:31:21 | 显示全部楼层
Listen to sqysl. Read the original article with context and you'll see any guess without the context is likely to be wrong:
http://searchoracle.techtarget.c ... ign-keys-be-indexed
"So, when do you not need to index a foreign key? In general, when the following conditions are met:
...[the quoted text]..."
Yong Huang
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行