Table count in From clause

Question

Post reply

Table count in From clause

karthik M

One Orange Chip

Points: 29139
More actions
September 10, 2007 at 9:51 am

#125657

Hi Experts,
How many tables are joined together in a single From Clause ?
Inputs are welcome !
Regards
Karthik

karthik

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

David McFarland SSChampion Points: 11815 More actions · Answer 1

As many as you need?

If you're asking for the maximum, I believe it's 256 in SS 2000.

karthik M One Orange Chip Points: 29139 More actions · Answer 2

When i increate my table count in the where clause , will it affect query performance or not ?

karthik

David McFarland SSChampion Points: 11815 More actions · Answer 3

It depends.

Some three table queries run far faster than some two table queries. How the tables and indexes are designed and defined, as well as the coding itself, has a far greater influence on performance than simply a count of the joins.