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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 这个问题该从那些方面考虑?
: 不知道这是不是和搜索的算法有关? 还是跟如何构建数据库有关?
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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 这个问题该从那些方面考虑?
: 不知道这是不是和搜索的算法有关? 还是跟如何构建数据库有关?
相关阅读
Access to a path is denied across domains如何寫此 SQL 查詢?MSSQL 2005, Database mail不工作了熟悉SEM, SEO的进来看一下这个数据优化吧?SSIS PKG是怎么从DEVELOPMENT装到PRODUCTION的请问那种很复杂的sql语句,有什么套路吗?再问CS的方向选择问题请问有什么好的SQL Server Clustering 的书或training 推荐的吗?Oracle一问各位大爷, 求求各位考过70-431的大爷给我指点(下星期就考了)最近找工作的经验 SQL DBA请问个join的问题我应该装那一款mySQL啊?什么地方有SQL习题集?NOT= , NOT IN 有啥区别mysql vs. postgre, 哪个比较好啊?请教一下,70-432和72-432证书是一样吗?Oracel, My SQL是不是case sensitive?journal for sql serverSQL中NOT EXIST和NOT IN有什么区别?