Post reply

How to get statistics information

  • March 16, 2008 at 11:04 pm

    #184156

    Hi all,

    🙂 i am working with mysql server 4.1.version.what is the command to get the statistics information regarding mytables?

    Thanks,

    Kiran

  • March 17, 2008 at 7:40 am

    #790338

    Someone might know the answer, but the forum here is for Microsoft SQL Server 2005. You'll more likely to get information by posting that question at a forum for the product you're asking about. There are a LOT of informed people here. You might get a good answer.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 17, 2008 at 1:28 pm

    #790531

    In SQL Server, we can use sp_helpindex

    In MySQL, you may try

    mysql> SHOW INDEX FROM mytable FROM mydb

    mysql> SHOW INDEX FROM mydb.mytabl

    May them help.

  • March 17, 2008 at 11:26 pm

    #790680

    Thanks for the information.

    Thanks,

    Kiran

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply