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
相关阅读
MySQL怎么远程地set Text或Blob column?谁在Fedora Core2 上安装过oracle 9.2.0.4?JSP access database的问题考MCDBA还是ORACLE的证书？免费下载的Oracle跟买的没有区别吗？问个初级问题help with a tedious querythread pooling in databae?怎么做哈请教考MCAD里SQL的经验oracle 10g certificateHow to change Access specification?Perl安装DBD::oracle的问题(linux,server不在本机）[转载] mysql database questionsecure website using oraclehow to using sql generate sql statements?unixODBC谁有常见Database interview questions?老板的无理要求！(希望熟悉Oracle的朋友指点)Need help on VBA! Please!