Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Several million records in Sql Server
Message
 
To
01/07/2003 12:03:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00805281
Message ID:
00805749
Views:
22
>3. Joins are always expensive. Querying a large de-normalized table with proper indexes will always return data faster than querying a highly normalized table that requires multiple joins even with correct indexes.

As you are mentioning "proper indexes" - is there anything like our SYS(3054) in SQL Server?

>4. http://www.sqlservercentral.com/ is a great site for SQL developers. It is to SQL what the UT is to VFP developers. Check it out.
Thanks for the tip!

Patrick
Previous
Reply
Map
View

Click here to load this message in the networking platform