Hi all,
I have read this for optimize the query.
"Query Optimizer for the Microsoft Jet database engine
The Jet database engine contains several components, but the most important component to queries (and the most complex) is the Optimizer. The Optimizer is cost-based. This means that the Optimizer assigns a time cost to each query task and then chooses the least expensive list of tasks to perform that generates the intended result set. The longer a task takes to perform, the more expensive that task is.
To decide what query strategy to use, the Optimizer uses statistics. The following factors are some of the factors that these statistics are based on: •The number of records in a table• The number of data pages in a table•The location of the table•Whether indexes are present "
I have this for improve performance.
is it means we cannot insert more records or what.
Can any one clarify this.
Thanks.
I have read this for optimize the query.
"Query Optimizer for the Microsoft Jet database engine
The Jet database engine contains several components, but the most important component to queries (and the most complex) is the Optimizer. The Optimizer is cost-based. This means that the Optimizer assigns a time cost to each query task and then chooses the least expensive list of tasks to perform that generates the intended result set. The longer a task takes to perform, the more expensive that task is.
To decide what query strategy to use, the Optimizer uses statistics. The following factors are some of the factors that these statistics are based on: •The number of records in a table• The number of data pages in a table•The location of the table•Whether indexes are present "
I have this for improve performance.
is it means we cannot insert more records or what.
Can any one clarify this.
Thanks.
