[SQL] count(*) optimization

[Nikola Ivacic]

Hi   I have trouble executing count(*) statement. On a large dataset it takes quite a while to return result. Is there any other way to get number of tupples in relation or is the only way to optimize count() function to index it?    thanks   Nikola