|
Home > Archive > SQL Anywhere database > July 2005 > Create statistics and create index
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Create statistics and create index
|
|
|
| Using ASA 9.0.2.3044 on WinXp sp1.
We are moving data between databases with unload and load.
Create statics is then called, and later on indexes may be created.
(I know load may create statistics on it's own, but thats different
matter).
So, does it have any effect on the optimizer, that indexes are created
after create statistics? I other words, would the optimizer benefit from
knowing about indexes when I call create statistics?
regards/Peter Simonsen
| |
| anil k goel 2005-07-28, 9:23 am |
| No, create statistics itself does not benefit from having indexes around.
BTW, create index will also create statistics on the indexed columns if the
stats don't exist already.
--
-anil
Research and Development, Query Processing
iAnywhere Solutions Engineering
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------
<Peter Simonsen> wrote in message news:42e89577$1@foru
ms-2-dub...
> Using ASA 9.0.2.3044 on WinXp sp1.
>
> We are moving data between databases with unload and load.
> Create statics is then called, and later on indexes may be created.
> (I know load may create statistics on it's own, but thats different
> matter).
>
> So, does it have any effect on the optimizer, that indexes are created
> after create statistics? I other words, would the optimizer benefit from
> knowing about indexes when I call create statistics?
>
> regards/Peter Simonsen
>
>
|
|
|
|
|