Sample database

You can set up the Netezza Performance Server sample database on your system if you are new to Netezza Performance Server and want to test basic queries. This database comes with a preconfigured database schema, which includes objects such as tables, views, and global objects, and has predefined data.

Available test scenarios

With the sample database, you can test following scenarios. You can run all of the tests or run a single test.
  • test_select
  • test_insert
  • test_create
  • test_mview
  • test_comparison_operators
  • test_aggregate
  • test_clauses
  • test_set_operators
  • test_inner_join
  • test_right_outer_join
  • test_left_outer_join
  • test_full_outer_join
  • test_cross_join
  • test_udx
  • test_corelated
  • test_stored_procedure
  • test_new_datatypes_JSON_JSONB_JSONPATH
  • test_alter
  • test_update
  • test_delete
  • test_truncate