This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 我们公司的DBA Manager说: 一个表, 如果只有non cluster index, then it makes no sense. 真的是这样吗? 就是必须有一个cluster index?
-outlink(outlink);
2013-2-10
(#8048673@0)
-
说的没错。可以不加index，既然用了index，至少要一个cluster的。
-bdbs(不多不少);
2013-2-10
(#8048677@0)
-
什么数据库？
-testabc(testabc);
2013-2-10
(#8048785@0)
-
as long as you could add indexes to the table, you should have clustered index. period.
-ssy214(村长);
2013-2-11
(#8049424@0)
-
Not really, a heap table is table without cluster index but with a or more non cluster indexes.
-deep_blue(BLUE);
2013-2-11
(#8049485@0)
-
You did not understand the question. Heap tables do exist, but it's something that should be avoided in design.
-ssy214(村长);
2013-2-11
(#8049589@0)
-
Although in most cases we should use clustered index table, the heap tables are useful in some cases.
-deep_blue(BLUE);
2013-2-11
(#8049709@0)
-
简单的说，不仅不必须，而且经常是anti-pattern。具体一点说，OLTP里基本上不应该加，传统的ETL based OLAP，往往这么做。但是现在OLAP的潮流是Big Data，能不能要不要用cluster index，应该具体情况具体分析。
-geekcode(吉克码工);
2013-2-12
(#8052480@0)
-
已经决定加index了. 在这种前提下, 必须有一个clustered index. 这才是要问的.
-outlink(outlink);
2013-2-20
(#8063663@0)
-
这句话在不同的语言环境里，有不同的含义。如果你是新手，那么对方是正确的。
如果你很确定知道自己在做什么，那么对方很可能是老黄历了。
如果是后面那种情况，你可以收集一些证据，来说服他，证明自己。
-szs11(不器);
2013-2-12
{156}
(#8052514@0)
-
各位高手们，这个叫clustered index，不是cluster index。。。低手打酱油路过
-natureguy(枫);
2013-2-12
(#8052527@0)
-
哪里哪里, 这个坛子里你最高.
-outlink(outlink);
2013-2-13
(#8052671@0)
-
汗一个。：（
-geekcode(吉克码工);
2013-2-13
(#8054407@0)
-
this is really a bad dba manager. this is why so many system did not perform well. it is really need to understand what the major use case for the table.
-newttc2000(frank);
2013-4-13
(#8149916@0)