![]() ![]() It was discovered in 1610 by Galileo Galilei and was named after the mythological character Io, a priestess of Hera who became one of Zeus's lovers. Slightly larger than Earth’s moon, Io is the fourth-largest moon in the Solar System, has the highest density of any moon, the strongest surface gravity of any moon, and the lowest amount of water (by atomic ratio) of any known astronomical object in the Solar System. oʊ/), or Jupiter I, is the innermost and third-largest of the four Galilean moons of the planet Jupiter. The setting of SET STATISTICS IO is set at execute or run time and not at parse time.Io ( / ˈ aɪ. Includes text, ntext, image, varchar(max), nvarchar(max), varbinary(max), or columnstore index pages. Number of pages placed into the cache for the query. Number of pages read from the data cache. Scan count is N when N is the number of different seeks or scans started towards the left or right side at the leaf level after locating a key value using the index key. For example, WHERE Clustered_Index_Key_Column =. This process is done to check for duplicate values for the key value that you're searching for. Scan count is 1 when you're searching for one value using a non-unique clustered index defined on a non-primary key column. Scan count is 0 if the index used is a unique index or clustered index on a primary key and you're seeking for only one value. Number of seeks or scans started after reaching the leaf level in any direction to retrieve all the values to construct the final dataset for the output. The following table lists and describes the output items. ![]() When STATISTICS IO is ON, statistical information is displayed, and when OFF, the information isn't displayed.Īfter this option is set ON, all Transact-SQL statements return the statistical information until the option is set to OFF. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |