答复: how to get the levels of a table or a index in Mysql 5.6?

The level is the height of a B-tree table or a B-tree index in mysql 5.6. My question is how to get the height(blevel) of a B-tree table or a B-tree index in mysql 5.6? Thanks. In oracle database,we can use the following statement to query the blevel of a index select index_name,blevel

RE: how to get the levels of a table or a index in Mysql 5.6?

Or maybe the number of levels in the BTree? Rule of Thumb: logarithm base 100 > -Original Message- > From: Hartmut Holzgraefe [mailto:hart...@skysql.com] > Sent: Monday, July 08, 2013 6:38 AM > To: mysql@lists.mysql.com > Subject: Re: how to get the levels of a table or a

Re: how to get the levels of a table or a index in Mysql 5.6?

On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote: > how to get the levels of a table or a index in Mysql 5.6? Level? What is level supposed to be in that context? Cardinality? Or something completely different? /me confused ... -- Hartmut Holzgraefe Principal Support Engineer (EMEA) SkySQL

how to get the levels of a table or a index in Mysql 5.6?

Hi how to get the levels of a table or a index in Mysql 5.6? thanks The information in this email is confidential and may be legally privileged. If you have

Re: index in mysql

t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 13, 2002 4:42 PM Subject: index in mysql > Hi all, > I have a quation about index: > In mysql, if i create table table_name with column loc_name (and another > columns), > and the col_name has PRIMARY KEY

index in mysql

Hi all, I have a quation about index: In mysql, if i create table table_name with column loc_name (and another columns), and the col_name has PRIMARY KEY and UNIQUE constraints, Is an index created atoumaticly on this column? Thanks, Inbal

RE: Do index in MySQL is case insensitive?

o: '[EMAIL PROTECTED]' Subject: Do index in MySQL is case insensitive? I have heard from somebody that MySQL index is case insensitive. If this is true, how can I set it to case sensitive? - Before posting, p

Re: Do index in MySQL is case insensitive?

2001 18:42 Subject: Do index in MySQL is case insensitive? > I have heard from somebody that MySQL index is case insensitive. If this is > true, how can I set it to case sensitive? > - Before posting, please check:

Do index in MySQL is case insensitive?

I have heard from somebody that MySQL index is case insensitive. If this is true, how can I set it to case sensitive?