The following is another example of how row-limiting clause can be applied. Row limiting clauses can be any select statements, this includes CREATE TABLE AS SELECT statements.
In the following example, we are able to create a new table in our PeopleSoft database by selecting the top 10% of rows by EMPLID.
You may recall from previous posts that CTAS operations in Oracle 12c include statistics. This is true for operations which include the Row-Limiting clauses as well.
In the following example, we are able to create a new table in our PeopleSoft database by selecting the top 10% of rows by EMPLID.
You may recall from previous posts that CTAS operations in Oracle 12c include statistics. This is true for operations which include the Row-Limiting clauses as well.
As you can see, we have a new table, with a brand new set of statistics to go along with it.
Comments
Post a Comment