执行查询语句的问题

a1024k

sybase12.5,solaris8,
sybase的内存配置是800000一执行大的查询如not in,in等就会执行不了，而且备份服务回自动down掉。
请问各位高手是什么原因？？

simbalwd

errorlog里写的什么？

a1024k

00:00000:00001:2004/03/17 23:58:00.14 server  Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00012:2004/03/18 00:10:22.41 server  Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00025:2004/03/18 19:20:00.72 server  Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00022:2004/03/19 08:16:58.93 server  Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00022:2004/03/20 10:58:21.45 server  Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00011:2004/03/22 09:18:17.36 server  Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00026:2004/03/22 15:58:37.06 server  Process id 27 killed by Hostname WinNT, Host process id 1856.
00:00000:00026:2004/03/22 15:59:42.91 server  Process id 19 killed by Hostname WinNT, Host process id 1856.
00:00000:00026:2004/03/22 15:59:51.29 server  Process id 30 killed by Hostname WinNT, Host process id 1856.
00:00000:00014:2004/03/23 08:16:47.04 server  Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00009:2004/03/24 00:37:52.85 server  Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
是不是'number of open objects参数不对，我用的是默认值

1017of

number of objects和number of indexes需要改改，另外干吗要用in啊？系统再好也别浪费嘛！

Eisen

多用exists 少用in

lake_fu

最好别用not in

a1024k

非常感谢，我再试一下！！谢谢大家！

solofeng

重新配置系统参数

hu-yf

not in 非常耗费资源。尽量不用。
你的index可能没用上。