AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
To do so, issue the following statement: ANALYZE TABLE COMPUTE STATISTICS Īlternatively, you can estimate the statistics on a sample of the table as follows: ANALYZE TABLE ESTIMATE STATISTICS 1000 ROWS To allow the optimizer to better estimate costs, you can calculate the statistics on the table you query. By default, Oracle Text uses the cost-based optimizer to determine the best execution plan for a query.
0 Comments
Read More
Leave a Reply. |