ChinaUnix.net
相关文章推荐:

index of qtsdk

Here is a list of what package each GNU program or library is in. - ........................ rc -- ....................... rc --p ...................... rc -p ....................... rc .gitaction .............. git 4dview ............. geomview a2p .................... perl a2x .................... xopt ac ..................... acct accton ................. acct aclocal ............ automake acm ...

by qingfenglala - Linux文档专区 - 2009-08-20 13:03:25 阅读(1029) 回复(0)

相关讨论

我运行: USE NorthWind GO SELECT companyname, contactname, city, country, phone FROM customers order by companyname companyname, contactname, city, country, phone 是一个名字叫contact的non-cluster index, 当有order by 语句的时候,excution plan 用的是contact index来scan index.当没有order by 的时候为什么用的是主键(PK)来查询(scan)呢?

by berserk_2nd - SQL server - 2007-09-27 09:12:45 阅读(2727) 回复(3)

.... -- ============================================================ -- Table: XXX -- ============================================================ create table XXX ( USER_ID INTEGER not null , LOCALE_ID INTEGER not null , CREATE_BY VARGRAPHIC(60) ...

by watsonyaya - DB2 - 2007-03-09 23:35:27 阅读(2061) 回复(3)

我看ocp 教材上写bitmap index efficient for queries using or predicates. 可是我怎么也想不明白为什么?那位大哥能解释一下. 我在线等!!!!!!!!!

by huangd - Oracle - 2007-01-06 17:29:01 阅读(1033) 回复(1)

现在因为数据库过于庞大,想对一些不常的索引DELETE,是否有办法知道索引的使用频率,以便找出很少甚至不使用的index,将其DELETE,以节约DBSPACE。 请教

by zhbw - Informix - 2006-11-04 11:20:08 阅读(1432) 回复(0)

各位好,我是一位新手,希望得到大家的帮助。 在测试index命令时,有一点不解,例: #!/usr/bin/perl -w index " a boy","boy"; 执行后提示: useless use of index in void context at ii.pl line 2. 这里上下文怎么是无效? 求解,谢谢!

by hb12112 - Perl - 2006-03-24 22:27:22 阅读(1745) 回复(3)

建了一个表和一个index 然后一行update了 index文件有什么变化?

by ipig - PostgreSQL - 2006-01-17 09:28:04 阅读(2225) 回复(1)

IF my sql query does not know how to pick up the index which i created earlier then what should i do???

by toms1981 - DB2 - 2004-08-03 11:00:59 阅读(905) 回复(1)

I wish to know how I going to know am I create a correct index? Can any provide some examples for creating a proper index? THANKS...

by toms1981 - DB2 - 2004-07-08 17:05:05 阅读(1051) 回复(3)

powerdesigner 检查模板时大量报告: existence of index 信息,请问是什么意思?怎么解决? 另: powerdesigner 中怎样建主外键(除了拖动指向)? 缺省命名如:Reference_18有必要改成规范的命名吗?

by Arrayliboinc - SQL server - 2004-04-20 16:13:19 阅读(3401) 回复(1)

select acct_id,sum(charge) from acct_item where acct_id in ( select acct_id from tmp_62) and state in ('20C','20T') group by acct_id; 这个语句如果不加任何提示不会用上索引,执行得很慢。 SELECT /*+ index(acct_item,idx_acct_item_acct) */ acct_id, SUM (charge) FROM acct_item WHERE acct_id IN ( SELECT acct_id FROM tmp_62) AND state IN ('20C', '20T') GROUP BY acct_id 如果加了索引提示就能使用...

by slightsnow - Oracle - 2004-03-10 12:37:12 阅读(784) 回复(1)