virtual column make sqlserver using function index
In sqlserver, it is impossible that if we want to create an function index. Doesn`t means we can not ?
Father said there always a way. That is virtual column.
Here is an exmple:
Sample 1
create table #checkdistribute ([CELL_ID] [varchar](20) NOT NULL)
create table #checkdistribute1 ([CELL_ID1] [varchar](2) NOT NULL)
INSERT #checkdistribute (CELL_ID) select CELL_ID from T with(nolock)
create NONCLUSTERED INDEX IDX_checkdistribute_cellid on #checkdistribute (CELL_ID asc)
INSERT #checkdistribute1 (CELL_ID1) select SUBSTRING(CELL_ID,1,2) from #checkdistribute
Although we generated an index but it still can not be use,. Because , Yes, SUBSTRING
Yes, Tables Scan.
Just wait. we also have a hope.
Sample 2
create table #checkdistribute ([CELL_ID] [varchar](20) NOT NULL,[CELL_ID_F] AS SUBSTRING(CELL_ID,1,2) )
create table #checkdistribute1 ([CELL_ID1] [varchar](2) NOT NULL)
INSERT #checkdistribute (CELL_ID) select CELL_ID from T with(nolock)
create NONCLUSTERED INDEX IDX_checkdistribute_cellid on #checkdistribute ([CELL_ID_F] asc)
INSERT #checkdistribute1 (CELL_ID1) select CELL_ID_F from #checkdistribute
It works
最新文章
- MSVCRTD.lib(mfc.obj) : error LNK2019: 无法解析的外部符号 _WinMain@16,该符号在函数 ___tmainC (转)
- url结构说明
- kali linux安装virtualbox虚拟机之爬坑经历
- CSS3匹配屏幕横竖状态
- HAProxy+Keepalived+PXC负载均衡和高可用的PXC环境
- 3xian退役贴【深思。】
- 在win7在结构cocos2d-x v3.2rc0开发环境(For Android)
- Random Forest Classification of Mushrooms
- Web部分
- 关于实体类getset方法首字母小写问题
- ElasticsearchCRUD翻译系列之(一): ElasticsearchCRUD 介绍
- 爬取qq号
- 你不知道的JavaScript中,读书笔记
- linux /proc目录说明(访问内核数据结构,修改内核设置)
- js异步计时器
- openssl证书及配置
- docker使用web界面管理Registry
- source Insight工程的简单使用
- Pandas dataframe 与 Spark dataframe 的区别
- openfire 详细介绍一
热门文章
- 91云服务器网络带宽测试,IO测试、全国ping测试
- acm数论之旅--数论四大定理
- 一周搞定模拟电路_P5_基本放电电路记录
- markdown简1
- jquery Ajax标准规范写法
- 写作环境搭建(git+github+markdown+jekyll)
- 「CF1042F」Leaf Sets
- CodeForces-220B Little Elephant and Array
- docker+hexo 搭建博客
- JSP页面中关于<;c:if test=";${...}";>;<;c:if>;标签的用法