Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Dot_Net-Chinese
Home
+ new post
Pages
Files
About this group
Join this group
SQL索引方法
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   6 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
icemerlin99  
View profile   Translate to Translated (View Original)
 More options Apr 10 2006, 5:33 am
From: "icemerlin99" <iceda...@gmail.com>
Date: Mon, 10 Apr 2006 09:33:44 -0000
Local: Mon, Apr 10 2006 5:33 am
Subject: SQL索引方法
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
★叮叮★(4183114) 17:27:19
石头，能说明一下索引的用法嘛？分几种？
★叮叮★(4183114) 17:27:52
这是上次某技术负责人给偶的题目，偶跟未来都对不上了

水月是小白(191085838) 17:19:55
做成专题讲座吧
lee(31479597) 17:21:37
嘛叫eclipse，好吃么
石头(6866288) 17:22:01
我可能还没你知道的多

石头(6866288) 17:22:05
索引分两种 一种是聚簇索引 一种是非聚簇索引
黄瓜  (170866611) 17:22:23
聚簇快，另种不快
黄瓜  (170866611) 17:22:27
前都唯一
灰色狍鸮(4502715) 17:22:30
lee又进入123状态了？
黄瓜  (170866611) 17:22:34
后者可不唯一
黄瓜  (170866611) 17:22:42
好像是这么说
石头(6866288) 17:23:05
对于聚簇索引
数据的物理存储位置是根据索引的顺序来排列的

黄瓜  (170866611) 17:23:13
若有时段查询，可以将 时间字段弄成聚簇索引，猛快


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
icemerlin99  
View profile   Translate to Translated (View Original)
 More options Apr 10 2006, 5:39 am
From: "icemerlin99" <iceda...@gmail.com>
Date: Mon, 10 Apr 2006 09:39:06 -0000
Local: Mon, Apr 10 2006 5:39 am
Subject: Re: SQL索引方法
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
石头(6866288) 17:28:24
对于聚簇索引
数据的物理存储位置是根据索引的顺序来排列的  因此
如果有聚簇索引
每一次插入都可能会引起数据页的移动 操作 所以
聚簇索引 适合那种频繁查询纪录得表  但不适合频繁
插入删除记录的表
石头(6866288) 17:29:24
非聚簇索引 就简单了 只是有个索引
数据的排列是无序的
黄瓜  (170866611) 17:29:47
学了一点
黄瓜  (170866611) 17:30:13
聚簇索引 适合那种频繁查询纪录得表  但不适合频繁
插入删除记录的表

一个表只能有一个聚簇索引


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "答复: Re: SQL索引方法" by zhangji...@digitalchina.com
zhangji...@digitalchina.com  
View profile   Translate to Translated (View Original)
 More options Apr 10 2006, 5:38 am
From: zhangji...@digitalchina.com
Date: Mon, 10 Apr 2006 17:38:18 +0800
Local: Mon, Apr 10 2006 5:38 am
Subject: 答复: Re: SQL索引方法
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

你们什么时候讨论的？？
Best Regards.
==========================================
张剑                          产品研发部
神州数码管理系统有限公司
上海市天山西路789号临空经济园区二楼252室
邮编:200335
电话:（021）62385577-8062
E-Mail:zhangji...@digitalchina.com
http://www.dcms.com.cn
==========================================

             "icemerlin99"                                                
             <iceda...@gmail.c                                            
             om>                                                    收件人
             发件人:                   "Dot_Net-Chinese"                  
             Dot_Net-Chinese@g         <Dot_Net-Chinese@googlegroups.com>  
             ooglegroups.com                                          抄送

                                                                      主题
             2006-04-10 17:39          Re: SQL索引方法                    

                 请答复 给                                                
             Dot_Net-Chinese@g                                            
              ooglegroups.com                                              

石头(6866288) 17:28:24
对于聚簇索引
数据的物理存储位置是根据索引的顺序来排列的  因此
如果有聚簇索引
每一次插入都可能会引起数据页的移动 操作 所以
聚簇索引 适合那种频繁查询纪录得表  但不适合频繁
插入删除记录的表
石头(6866288) 17:29:24
非聚簇索引 就简单了 只是有个索引
数据的排列是无序的
黄瓜  (170866611) 17:29:47
学了一点
黄瓜  (170866611) 17:30:13
聚簇索引 适合那种频繁查询纪录得表  但不适合频繁
插入删除记录的表

一个表只能有一个聚簇索引


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
icemerlin99  
View profile   Translate to Translated (View Original)
 More options Apr 10 2006, 5:43 am
From: "icemerlin99" <iceda...@gmail.com>
Date: Mon, 10 Apr 2006 09:43:24 -0000
Local: Mon, Apr 10 2006 5:43 am
Subject: Re: 答复: Re: SQL索引方法
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
现在进行中，在qq上，未来的智慧之美里

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "答复: Re: 答复: Re: SQL索引方法" by zhangji...@digitalchina.com
zhangji...@digitalchina.com  
View profile   Translate to Translated (View Original)
 More options Apr 10 2006, 5:56 am
From: zhangji...@digitalchina.com
Date: Mon, 10 Apr 2006 17:56:46 +0800
Local: Mon, Apr 10 2006 5:56 am
Subject: 答复: Re: 答复: Re: SQL索引方法
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

怎么没有我？加我进去啊！
Best Regards.
==========================================
张剑                          产品研发部
神州数码管理系统有限公司
上海市天山西路789号临空经济园区二楼252室
邮编:200335
电话:（021）62385577-8062
E-Mail:zhangji...@digitalchina.com
http://www.dcms.com.cn
==========================================

             "icemerlin99"                                                
             <iceda...@gmail.c                                            
             om>                                                    收件人
             发件人:                   "Dot_Net-Chinese"                  
             Dot_Net-Chinese@g         <Dot_Net-Chinese@googlegroups.com>  
             ooglegroups.com                                          抄送

                                                                      主题
             2006-04-10 17:43          Re: 答复: Re: SQL索引方法          

                 请答复 给                                                
             Dot_Net-Chinese@g                                            
              ooglegroups.com                                              

现在进行中，在qq上，未来的智慧之美里


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
叮叮  
View profile   Translate to Translated (View Original)
 More options Apr 10 2006, 6:00 am
From: "叮叮" <iceda...@gmail.com>
Date: Mon, 10 Apr 2006 18:00:58 +0800
Local: Mon, Apr 10 2006 6:00 am
Subject: Re: 答复: Re: 答复: Re: SQL索引方法
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

找未来，我已经下QQ了~~呵呵，让他给你号~~
我下班回家了阿~~

在06-4-10，zhangji...@digitalchina.com <zhangji...@digitalchina.com> 写道：

--
________________________________
http://spaces.msn.com/icemerlin99

    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google