Illustrates the term update statistics in Sybase
Illustrates the term update statistics in Sybase?
Expert
The update statistics command assists the server make the best decisions about that indexes to use when this processes a query, by giving information about the distribution of the key values within the indexes. There update statistics commands create statistics, when there are no statistics for an exact column, or replaces existing statistics when they already exist. The statistics are stored within the system tables as systabstats and sysstatistics.
Does the minimum spanning tree of a graph provide the shortest distance in between any of two gives nodes?
Specify the various advantages of the Lookup persistent cache?
List out the three kinds of business rules and also define each of them?
Write down the level of Granularity of a fact table?
Can we stop and start one session in the concurrent batch?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Briefly define and describe the term data constraints?
Illustrates the term Open Server in Sybase?
Illustrates the term explain and how does this work?
Explain the following terms: Proactive, Retroactive and immediate Update.
18,76,764
1922942 Asked
3,689
Active Tutors
1413587
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!