multiple indexes or a composite index?

I was just wondering if anyone has any general guidelines to follow that might help identify situations where one should use a composite index rather than multiple indexes on the individual columns. Focusing only on performance, rather than integrity...I've always been able to get faster queries and better execution plans when I've used separate indexes on the columns and I was wondering what situations are more suitable for performance improvements by way of a composite index?

Thanks,
Gavin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Aug 27 2000 - 13:10:19 CDT