We have an app currently being built that uses VB.Net and SQL Compact on a Windows Mobile 4.20 device (bar scanner). We need to update from the device to a desktop-based engine - we have no access to a SQL Server unless you'd count something like SQL Express as
When I run UPDATE STATISTICS on an index I sometimes get this message "Statistics on this index do not exist". Is there any way I can check wether an index has statistics or not. I have looked at the INFORMATION_SCHEMA.INDEXES view but havent found out how I can