Redian新闻
>
How to defind query input obs number???
avatar
How to defind query input obs number???# Database - 数据库
r*r
1
I have a query to run against a db with millions and millions of entries.
I'd like to test the query before running it against the entire db.
Is there a way to run the query against only the first 1000 entries?
5000 entries? X entries? Not 'LIMIT' 'TOP', they are for limitation only
on the result.
Thank you very much!!!
avatar
B*g
2
一看不是oracle,不会

【在 r****r 的大作中提到】
: I have a query to run against a db with millions and millions of entries.
: I'd like to test the query before running it against the entire db.
: Is there a way to run the query against only the first 1000 entries?
: 5000 entries? X entries? Not 'LIMIT' 'TOP', they are for limitation only
: on the result.
: Thank you very much!!!

avatar
j*n
3
SQL Server 的话除了用 top 1000, 其他的俺也不会
另,index 用对的话几百万的数据其实也没啥。
avatar
B*g
4
In oracle, 可以用fist n row hint, 不知道sql server有没有

【在 j*****n 的大作中提到】
: SQL Server 的话除了用 top 1000, 其他的俺也不会
: 另,index 用对的话几百万的数据其实也没啥。

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。