1. how many fields make up your search criteria?
2. What is the datatype of those fields?
3. Are those fields indexed, and if so are they being used?
4. What indexes are being used by your query?
5. What kinds of indexes are being used?
6. Are those indexes optimized?
7. What is the distribution of values within that index?
8. Are you running the query with an implicit or explicit transaction?
9. How many users are concurrently trying to access those rows (row lock
contention)?
10. What isolation level is your transaction using?
11. I'm sure there is more...
When in doubt, just fill the table with more data and see for yourself.
Paul Kenney
[EMAIL PROTECTED]
916-212-4359
> -----Original Message-----
> From: brobborb [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 06, 2004 12:38 PM
> To: CF-Talk
> Subject: SOT: SQL Query
>
>
> hey guys, what do u think the performance difference is in MS
> SQL Server 2000....
>
> Querying from a table of 500,000 rows or querying from a
> table of 1 million rows?
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
