开发者

index in oracle, clustered or unclustered [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

Is an index clustered or unclustered in Oracle?

i've a table with 3 imported key, there's an index for each of them, how can i verifity the type of index? If is it a clustered index (so the data pointed by index are ordered) or unclest开发者_JAVA技巧ered? thanks.


Oracle does not have a "clustered index" (at least not the way this term is used e.g. in SQL Server)

The closest thing to a clustered index is an index organized table in Oracle.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜