InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Do You Mean By Table Sample? |
|
Answer» TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM CLAUSE. The rows retrieved are random and they are not in any order. This sampling can be based on a PERCENTAGE of number of rows. You can use TABLESAMPLE when only a sampling of rows is necessary for the APPLICATION instead of a FULL result set. TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM clause. The rows retrieved are random and they are not in any order. This sampling can be based on a percentage of number of rows. You can use TABLESAMPLE when only a sampling of rows is necessary for the application instead of a full result set. |
|