Can you restrict the number of rows returned?
Hi There,
The client has a concern with long running queries. Some users are running query that take forever to return a value and slows down the entire database. The client asked if there is a way to restrict the number of rows returned. For example if a query is suppose to return 100,000 rows and takes super long time to return a value is it possible to assign the user to only return 1000 rows? After it reaches 1000 rows it will stop. I know that some tables don't have indexes on them and should be should be fixed as well. Maybe the resources can be restricted for that user? Please advise. Thanks
J