|
Тема |
Re: Моля за помощ за SQL заявка [re: Dakota] |
|
Автор |
st75 (непознат
) |
|
Публикувано | 14.06.11 16:41 |
|
|
FireBird е БД.
Това ли имаш предвид за EXPLAIN ?
Plan
PLAN JOIN (SKLAD ORDER SKLAD_NOMNOMER INDEX (LIST_INDEX), SKLRAZ INDEX (SKLRAZ_NOMNOMER), EKSBEL INDEX (EKSBEL_FULLNOMER))
------ Performance info ------
Prepare time = 15ms
Execute time = 1m 13s 360ms
Avg fetch time = 3 056.67 ms
Current memory = 17 514 916
Max memory = 17 779 804
Memory buffers = 2 048
Reads from disk to cache = 10 121 729
Writes from cache to disk = 0
Fetches from cache = 24 011 829
|
| |
|
|
|