r****r
发帖数: 1693 | 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!!! |
B*****g
发帖数: 34098 | 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!!!
|
j*****n
发帖数: 1781 | 3 SQL Server 的话除了用 top 1000, 其他的俺也不会
另，index 用对的话几百万的数据其实也没啥。 |
B*****g
发帖数: 34098 | 4 In oracle, 可以用fist n row hint， 不知道sql server有没有
【在 j*****n 的大作中提到】
: SQL Server 的话除了用 top 1000, 其他的俺也不会
: 另，index 用对的话几百万的数据其实也没啥。
|
