1 million row
-
Script to Create Huge Table for Performance Testing
1. Create table in the database CREATE TABLE speforums_bigtable ( id NUMBER(10), created_date DATE, lookup_id NUMBER(10), data VARCHAR2(50) ); 2. Execute following script to create 1000000 rows of data. This may take some time to complete the operation...- admin
- Resource
- 1 million row big table database performance testing date and time oracle partition dummy table performance testing speforums sample database table
- Category: Database Performance - Beginner Tutorials