Subject | Queries tuning... how to do it |
---|---|
Author | Xavier Solé |
Post date | 2003-03-26T10:58:02Z |
Hello listers,
I wonder where I could find any documents referred to query optimization
(tuning, improve speed). I don't know it this should be Firebird-specific or
they're just common SQL (or relational database) rules. The fact is that I
would like to know this "golden rules" that all SQL queries should take into
account. I've looked at Firebird website but haven't found any docs about
it.
Thanks for your help,
XS.
-------------------------------------------------
Xavier Solé - x.sole@...
Cancer Epidemiology
Catalan Institute of Oncology
Av. Gran Via s/n, km. 2,7
08907 L'Hospitalet de Llobregat,
Barcelona, Catalonia.
Tel: +34 93 260 74 01
Fax:+34 93 260 77 87
I wonder where I could find any documents referred to query optimization
(tuning, improve speed). I don't know it this should be Firebird-specific or
they're just common SQL (or relational database) rules. The fact is that I
would like to know this "golden rules" that all SQL queries should take into
account. I've looked at Firebird website but haven't found any docs about
it.
Thanks for your help,
XS.
-------------------------------------------------
Xavier Solé - x.sole@...
Cancer Epidemiology
Catalan Institute of Oncology
Av. Gran Via s/n, km. 2,7
08907 L'Hospitalet de Llobregat,
Barcelona, Catalonia.
Tel: +34 93 260 74 01
Fax:+34 93 260 77 87