I`m Looking for newbie articles about optimization,
at software level of the SQL ( By this i mean making the database run faster without having to upgrade the machine itself)
i have found myself quite plenty of material,
but i was wondering that someone here could point me a way into easy readable material, since lots of the material i've found require a certain knowledge of the subject.
any reference is welcome, articles, books, threads in the forum and so on.
i'n a newcomer to the forum so sorry if this goes against any policies of this forum
Thanks in advance
A separate but important point is to avoid using "select * ..." in queries as, by doing that, you're likely bringing back much more data to the caller than is really needed [and this can have a definitive speed impact depending on the number of times the query is called and the throughput of the network over which the data is being returned].