indexing就是设置primary key吗？# Database - 数据库
I*y
1 楼
在建mysql数据库table的时候，因为read这个表格多于insert, 想弄一个index, 根据我
现在的理解就是设置primary key, 请问这样理解对吗？
现在的理解就是设置primary key, 请问这样理解对吗？
B*g
2 楼
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
据我
【在 I*****y 的大作中提到】
: 在建mysql数据库table的时候，因为read这个表格多于insert, 想弄一个index, 根据我
: 现在的理解就是设置primary key, 请问这样理解对吗？
据我
【在 I*****y 的大作中提到】
: 在建mysql数据库table的时候，因为read这个表格多于insert, 想弄一个index, 根据我
: 现在的理解就是设置primary key, 请问这样理解对吗？
j*n
3 楼
not sure for mysql, but for MSSQL, if you specify a primary key, it will
automatically create a clustered index for you.
anyway, indexing is different thing with your PK...
get your knowledge updated by read some database fundamental books please.
automatically create a clustered index for you.
anyway, indexing is different thing with your PK...
get your knowledge updated by read some database fundamental books please.
w*e
4 楼
准确的说是: 如果没clustered Index, 那么it will automatically create a
clustered index on the PK for you.
如果有个clustered index 存在了, 那就是automatically create a non-clustered
index on that PK for you.
【在 j*****n 的大作中提到】
: not sure for mysql, but for MSSQL, if you specify a primary key, it will
: automatically create a clustered index for you.
: anyway, indexing is different thing with your PK...
: get your knowledge updated by read some database fundamental books please.
clustered index on the PK for you.
如果有个clustered index 存在了, 那就是automatically create a non-clustered
index on that PK for you.
【在 j*****n 的大作中提到】
: not sure for mysql, but for MSSQL, if you specify a primary key, it will
: automatically create a clustered index for you.
: anyway, indexing is different thing with your PK...
: get your knowledge updated by read some database fundamental books please.
j*n
5 楼
en, maybe you right, I just suppose that lz's table has no PK and indexes
yet.
btw, you can specify do not create clustered index for PK by default. it was
critical issue for MSSQL 6.5 when creating highly transactional OLTP. e.g.
1,000 inserts/second. it will cause "hotspot" problem when PK with clustered
index.
of course, it is already the history, just mention it for fun. :)
when you see some DB under such scenario, you can say, ha, it was originally
created under 6.5 version!
【在 w*******e 的大作中提到】
: 准确的说是: 如果没clustered Index, 那么it will automatically create a
: clustered index on the PK for you.
: 如果有个clustered index 存在了, 那就是automatically create a non-clustered
: index on that PK for you.
yet.
btw, you can specify do not create clustered index for PK by default. it was
critical issue for MSSQL 6.5 when creating highly transactional OLTP. e.g.
1,000 inserts/second. it will cause "hotspot" problem when PK with clustered
index.
of course, it is already the history, just mention it for fun. :)
when you see some DB under such scenario, you can say, ha, it was originally
created under 6.5 version!
【在 w*******e 的大作中提到】
: 准确的说是: 如果没clustered Index, 那么it will automatically create a
: clustered index on the PK for you.
: 如果有个clustered index 存在了, 那就是automatically create a non-clustered
: index on that PK for you.
u*u
6 楼
For any relational database (Oracle, MS SQL, MySQL, DB2...):
Primary key is a table constraint, it means Unique and NOT NULL.
alter table T add primary key (id); will create a primary key on id column,
in the meantime, it will also creat a uniq index on that id column.
You can create a unique index for id column on table T as below:
create unique index idx_t on t(id);
However, unique index column can be NULL.
Therefore, Unix index doesn't equal to primary key.
Send me email for more database q
Primary key is a table constraint, it means Unique and NOT NULL.
alter table T add primary key (id); will create a primary key on id column,
in the meantime, it will also creat a uniq index on that id column.
You can create a unique index for id column on table T as below:
create unique index idx_t on t(id);
However, unique index column can be NULL.
Therefore, Unix index doesn't equal to primary key.
Send me email for more database q
相关阅读
需要弄明白考什么database的证书Job openings with Teradata (zt)谁能推荐关于 sql query optimization 方面的书？请教：如何从group里面拿到最后一个record的全部数据(MS SQL)准备去考个sql server的432-450Recover postgresql 的问题出几个Senior SQL Server DBA 的面试题 (25个包子)在哪能找点私货干干?I think we should have a Business Intelligence 版data analyst 与database developerDBA职业要求Update: 招工：SQL Server developer w. SSIS新手问题求助database找工作求助 着急 感谢了下载mysql问题菜鸟求助:请推荐教程哪位知道扩展名为WK1的文件用什么软件可以打开？question about MS SQL mirroring...有没有java 高手？teradata 的问题