我们如何在oracle的主键列上创建非聚集索引？ [英] how we can create non clustered index on primary key column in oracle?

问题描述

请给我解决方案，我想在oracle的主键列上创建一个具有

非聚集索引的表吗？

我们如何才能实现这一目标给我解决方案

hi please give me solution for i want to create a table that has
non -clustered index on primary key column in oracle?
how we can achieve this please give me solution

推荐答案

SQL的集群/非集群索引的想法没有在Oracle中实现...有索引组织表服务于相同的目的（但不完全相同）...

要了解它，请在此处阅读...

constraint [ ^ ]

管理索引组织表 [ ^ ]

The idea of clustered/non-clustered indexes of SQL is not implemented in Oracle...There are 'Index-Organized Tables' that serve the same purpose (but not identical)...
To learn about it, read here...
constraint[^]
Managing Index-Organized Tables[^]

这篇关于我们如何在oracle的主键列上创建非聚集索引？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！