Hello I have a issue with a table containing countries info where one of the columns contains the geographical position of the country capital. This column data type is Geography.
The issue is that everyday the first time I execute a select on this table it takes more than 30 seconds to retrieve 270 records.
This happens only the first time after that the result is immediately retrieved.
Any one have an idea?