Technical process behind a query

[ScanX]

Hi

I would like to know if I could find some online information about how the data is processed behind an SQL statement

Especially the JOIN issue, I would like to know what are the performances problems when you link a huge table (1 billion rows) with an average table (few thousands of rows) and what creates these problems.

Thanx for help

 

[JeanNiBee]

You can get lots of information in the Sybase Performance and Tunig book which is downloadable from their website.

Just follow the 'support' and documentaton links.



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects