www.FiveTechSoft.com
https://fivetechsoft.com/forums/
Code: Select all
oVer := oServer:Query("SHOW INDEX FROM " + cTable + ";")Code: Select all
//Para una tabla
SELECT DISTINCT
TABLE_NAME,
INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_NAME = 'retalcal';
//Para todas las tablas de una BDD
SELECT DISTINCT
TABLE_NAME,
INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'fapsoftware';
vilian wrote:Hi Guys,
How could I know the indexes of a mysql table has ?
Code: Select all
aIndexes := oCn:ListIndexes( cTable )
Hi Mr. Rao,nageswaragunupudi wrote:vilian wrote:Hi Guys,
How could I know the indexes of a mysql table has ?Code: Select all
aIndexes := oCn:ListIndexes( cTable )
No.Is there any function to create index?
Code: Select all
METHOD MakePrimaryKey( cTable, cCol )Hi Mr. Rao,nageswaragunupudi wrote:No.Is there any function to create index?
Not exactly but this function automatically creates a primary key index:Code: Select all
METHOD MakePrimaryKey( cTable, cCol )
a) We need to create unique indexes for enforcing unique constraint for a column or set of columns. If we want to create unique constraint to a single column, we can either create while creating the table or later create a unique index by:Do you mean we don't need index other than a primary key?
Code: Select all
oCn:Execute( "CREATE UNIQUE INDEX cust_name_uidx ON cust( name )" )
Code: Select all
oCn:Execute( "CREATE INDEX ON employee___idx ON employee( _ )" )
We do it by creating foreign key relationships. Our library provides special features to deal with parent-child relationships and you can find samples in the samples folder as well in the forum if you search.Wouldn't it be better to index the connection variables of detail tables and master table?