On Saturday, June 28, 2008 at 6:14:04 AM UTC+1, Lennart Jonsson wrote:
On Jun 28, 4:51 am, "Frank Swarbrick"
<Frank.Swarbr...@efirstbank.com>
[...]
Thanks for the info. I understand now. Now I just need to decide if and when it makes sense to do it.
It's a trade off between the extra space used, and minimizing I/O. IMO
good candidates are small catalog tables, where the non indexed
column(s) are used in select statements frequently. Other than that I
tend to add include columns during performance test as part of
optimization.
/Lennart
Frank
https://calltrak.io
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)