On 10/22/10 11:50 AM, sunpeng wrote:
> what's the base of log_/a/ (/n/) function ? is that base a=16? or
> something else? how to know this base ?
>
> 2010/10/22 sunpeng <bluevaley(at)gmail(dot)com <mailto:bluevaley(at)gmail(dot)com>>
>
> Hi, how to get the height of R* or B tree of created index ?
>
>
it would be based on how many index values plus overhead fits in each 8K
block. highly variable if the field being indexed is TEXT or VARCHAR
or similar.