w*r
2 楼
search speed is largely determined by index + IO
well, if you can fit all index in your memory, then, there would be no
problem, if not, your IO is problem. Consider different techniques of
partitioning, join index and so on. for DB2 MDC is a must for large table,
for Teradata unique primary index + secondary index + partition(range) , for
Oracle, index organize table + bitmap index + index join hint in query.
【在 l****2 的大作中提到】
: 这个问题该从那些方面考虑?
: 不知道这是不是和搜索的算法有关? 还是跟如何构建数据库有关?
well, if you can fit all index in your memory, then, there would be no
problem, if not, your IO is problem. Consider different techniques of
partitioning, join index and so on. for DB2 MDC is a must for large table,
for Teradata unique primary index + secondary index + partition(range) , for
Oracle, index organize table + bitmap index + index join hint in query.
【在 l****2 的大作中提到】
: 这个问题该从那些方面考虑?
: 不知道这是不是和搜索的算法有关? 还是跟如何构建数据库有关?
相关阅读
import dump file[转载] SQL 2000不能装在win2000上吗？？？Re: 求教：哪里能找到introduction to oracle:sql and pl/sql student guidsqllib80.dlloracle startup help?oracle question[转载] Re: date conversionHelp needed in SQLSQL Server 2k textbook?请数据库高手指点一二 数据库应用程序服务器端的发布问题。long and CLOB.. any differences?Re: [转载] any free tool/program that can sync LDAP servers?请问：哪里有SQL Server下载？各位老大，管理数据库的用户，这样行吗？请教一个sql server的问题A question about Search Engine!SQL Server 7 application by ANSI C++Help! A SAS/Macro question. Thanks!'Yukon' to Add Run-Time, XML Support