~drizzle-trunk/drizzle/development

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

175

--replace_column 2 #

176

--sorted_result

177

175

show status like 'Last_query_cost';

178

176

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

179

--replace_column 2 #

180

--sorted_result

181

177

show status like 'Last_query_cost';

182

178

# 6-table join, star

183

--sorted_result

184

179

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

185

--replace_column 2 #

186

180

show status like 'Last_query_cost';

187

--sorted_result

188

181

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

189

--replace_column 2 #

190

182

show status like 'Last_query_cost';

191

183

# 6-table join, clique

192

--sorted_result

193

184

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;

194

--replace_column 2 #

195

185

show status like 'Last_query_cost';

196

186

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71 and t2.c22 = t3.c32 and t2.c23 = t4.c42 and t2.c24 = t5.c52 and t2.c25 = t6.c62 and t2.c26 = t7.c72 and t3.c33 = t4.c43 and t3.c34 = t5.c53 and t3.c35 = t6.c63 and t3.c36 = t7.c73 and t4.c42 = t5.c54 and t4.c43 = t6.c64 and t4.c44 = t7.c74 and t5.c52 = t6.c65 and t5.c53 = t7.c75 and t6.c62 = t7.c76;

197

--replace_column 2 #

198

187

show status like 'Last_query_cost';

199

188

200

189

207

196

select @@optimizer_search_depth;

208

197

209

198

# 6-table join, chain

210

--sorted_result

211

199

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

212

--replace_column 2 #

213

200

show status like 'Last_query_cost';

214

201

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

215

--replace_column 2 #

216

202

show status like 'Last_query_cost';

217

203

# 6-table join, star

218

--replace_column 2 #

219

--sorted_result

220

204

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

221

--replace_column 2 #

222

205

show status like 'Last_query_cost';

223

--sorted_result

224

206

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

225

--replace_column 2 #

226

207

show status like 'Last_query_cost';

227

--sorted_result

228

208

# 6-table join, clique

229

209

230

--replace_column 2 #

231

--sorted_result

232

210

show status like 'Last_query_cost';

233

211

234

--replace_column 2 #

235

212

show status like 'Last_query_cost';

236

213

237

214

set optimizer_search_depth=1;

238

215

select @@optimizer_search_depth;

239

216

240

217

# 6-table join, chain

241

--sorted_result

242

218

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

243

--replace_column 2 #

244

--sorted_result

245

219

show status like 'Last_query_cost';

246

220

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

247

--replace_column 2 #

248

--sorted_result

249

221

show status like 'Last_query_cost';

250

222

# 6-table join, star

251

--sorted_result

252

223

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

253

--replace_column 2 #

254

--sorted_result

255

224

show status like 'Last_query_cost';

256

225

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

257

--replace_column 2 #

258

--sorted_result

259

226

show status like 'Last_query_cost';

260

227

# 6-table join, clique

261

--sorted_result

262

228

263

--replace_column 2 #

264

--sorted_result

265

229

show status like 'Last_query_cost';

266

230

267

--replace_column 2 #

268

231

show status like 'Last_query_cost';

269

232

270

233

set optimizer_search_depth=62;

272

235

273

236

# 6-table join, chain

274

237

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

275

--replace_column 2 #

276

238

show status like 'Last_query_cost';

277

239

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

278

--replace_column 2 #

279

240

show status like 'Last_query_cost';

280

241

# 6-table join, star

281

--sorted_result

282

242

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

283

--replace_column 2 #

284

243

show status like 'Last_query_cost';

285

--sorted_result

286

244

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

287

--replace_column 2 #

288

245

show status like 'Last_query_cost';

289

246

# 6-table join, clique

290

--sorted_result

291

247

292

--replace_column 2 #

293

248

show status like 'Last_query_cost';

294

--sorted_result

295

249

296

--replace_column 2 #

297

250

show status like 'Last_query_cost';

298

251

299

252

305

258

306

259

# 6-table join, chain

307

260

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

308

--replace_column 2 #

309

261

show status like 'Last_query_cost';

310

262

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

311

--replace_column 2 #

312

263

show status like 'Last_query_cost';

313

264

# 6-table join, star

314

--sorted_result

315

265

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

316

--replace_column 2 #

317

--sorted_result

318

266

show status like 'Last_query_cost';

319

267

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

320

--replace_column 2 #

321

--sorted_result

322

268

show status like 'Last_query_cost';

323

269

# 6-table join, clique

324

270

325

--replace_column 2 #

326

271

show status like 'Last_query_cost';

327

272

328

--replace_column 2 #

329

273

show status like 'Last_query_cost';

330

274

331

275

set optimizer_search_depth=1;

333

277

334

278

# 6-table join, chain

335

279

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

336

--replace_column 2 #

337

280

show status like 'Last_query_cost';

338

281

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

339

--replace_column 2 #

340

282

show status like 'Last_query_cost';

341

283

# 6-table join, star

342

284

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

343

--replace_column 2 #

344

285

show status like 'Last_query_cost';

345

286

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

346

--replace_column 2 #

347

287

show status like 'Last_query_cost';

348

288

# 6-table join, clique

349

289

350

--replace_column 2 #

351

290

show status like 'Last_query_cost';

352

291

353

--replace_column 2 #

354

292

show status like 'Last_query_cost';

355

293

356

294

set optimizer_search_depth=62;

358

296

359

297

# 6-table join, chain

360

298

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

361

--replace_column 2 #

362

299

show status like 'Last_query_cost';

363

300

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c12 = t2.c21 and t2.c22 = t3.c31 and t3.c32 = t4.c41 and t4.c42 = t5.c51 and t5.c52 = t6.c61 and t6.c62 = t7.c71;

364

--replace_column 2 #

365

301

show status like 'Last_query_cost';

366

302

# 6-table join, star

367

303

explain select t1.c11 from t1, t2, t3, t4, t5, t6, t7 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

368

--replace_column 2 #

369

304

show status like 'Last_query_cost';

370

305

explain select t1.c11 from t7, t6, t5, t4, t3, t2, t1 where t1.c11 = t2.c21 and t1.c12 = t3.c31 and t1.c13 = t4.c41 and t1.c14 = t5.c51 and t1.c15 = t6.c61 and t1.c16 = t7.c71;

371

--replace_column 2 #

372

306

show status like 'Last_query_cost';

373

307

# 6-table join, clique

374

308

375

--replace_column 2 #

376

309

show status like 'Last_query_cost';

377

310

378

--replace_column 2 #

379

311

show status like 'Last_query_cost';

380

312

381

313

drop table t1,t2,t3,t4,t5,t6,t7;

Older »