help with a tedious query# Database - 数据库
j*i
1 楼
I have some huge tables to generate dynamic DDL,each table has about 30-50
fields,some table have 1 primary key, some table have 4 primary key like this:
Table T1 (PK1),T2(PK1,PK2,PK3,PK4),T3(PK1,PK2,PK3,PK4),T4(PK1,PK2,PK3,PK4),.
,
I may need to up to 200 fields in this query( may from 4-5 tables or more) and
I need to return 4000-5000 records each time at an acceptable speed.
The idea is:
use PK1 in TB1, then join other tables-T2,T3,T4 ...etc.
record number:
how many there in the query('X1','X
fields,some table have 1 primary key, some table have 4 primary key like this:
Table T1 (PK1),T2(PK1,PK2,PK3,PK4),T3(PK1,PK2,PK3,PK4),T4(PK1,PK2,PK3,PK4),.
,
I may need to up to 200 fields in this query( may from 4-5 tables or more) and
I need to return 4000-5000 records each time at an acceptable speed.
The idea is:
use PK1 in TB1, then join other tables-T2,T3,T4 ...etc.
record number:
how many there in the query('X1','X