23 lines
793 B
Plaintext
23 lines
793 B
Plaintext
# @(#)queries.readme 2.1.8.1
|
|
File: queries/README
|
|
Spec Revision: 1.0.1
|
|
Last Modified: 22 Apr 1999
|
|
|
|
This directory contains the current set of funtional query
|
|
definition templates. They are derived from the functional query
|
|
definitions presented in Clause 2 of the TPC-H and TPC-R Benchmark
|
|
Specifications and should allow the use of QGEN (see ../dbgen).
|
|
The template for query nn is stored in nn.sql.
|
|
|
|
Refer to Clause 2.2 for the permissible use of these templates.
|
|
|
|
|
|
Dec. 2004, M. Spiekermann
|
|
|
|
Files ending with ".pg" are translated to Postgres SQL syntax
|
|
and the files tpcX contain a query plan produced by SECONDOs
|
|
optimizer whereas the files tpcX_opt are hand tuned query plans.
|
|
|
|
The file tpcqueries.pl contains queries in a SQL like syntax suitable for
|
|
SECONDO's optimizer.
|