Faster count using sysindexes in a relational model 
Author Message
 Faster count using sysindexes in a relational model
The following statement:

SELECT rows
FROM sysindexes
WHERE id = OBJECT_ID('my_table') AND indid < 2

will be a lot faster than this statement:

SELECT count(*)
FROM my_table

Now, is it adapt this solution with a more complex count, based on field
content and even in a relational model?

Thanks for any input!



Wed, 02 Feb 2005 02:45:51 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Faster count method using sysindexes on complex query

2. Mining model using relational data

3. sdm model to relational model

4. map SDM model to relational model

5. Propositional Data Model (beyond Relational Data Model)

6. Fast table count or table block count needed.

7. row count in sysindexes

8. Incorrect row count from sysindexes

9. Syntax error COUNT() : Using COUNT() with char field

10. using SELECT COUNT(*) to count distinct records

11. A Relational Model Question

12. design question: storing object-oreinted information in a relational model


 
Powered by phpBB® Forum Software