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 的大作中提到】
: 这个问题该从那些方面考虑?
: 不知道这是不是和搜索的算法有关? 还是跟如何构建数据库有关?
相关阅读
请问如何有效快速搜索一个很大的数据库?Question on create a database in DB2SQL questionsql questionData warehouse textbook心急如焚,升级MT后MySQL的数据全变乱码了MySQL的InnoDB表不支持full text index 怎么办?诚请推荐管理记事软件 (转载)a beginner questionwww.kollegian.com 上有很多便宜的课本和其他书籍,而且可以免费卖书MySQL起不来了。A SQL question请教一个sql的问题请教一个SQL Query新手土问题:现在还用Pro* C 调用,访问SQL数据库吗?zz: Oracle数据库加密曝漏洞 几分钟即可破解一个奇怪的问题快速搜索very large database的问题新手求救:如何给我sort完的表填加一列自然数显示order?请教:how to call a COM object in a stored procedure?