big table

  • perf-test.com need your contributions to build up a strong repository of performance engineering resources.

  1. admin

    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...