Database reference - demo

demo -  indexes

Index overview

nametablesize (kb)description
IX_customer_nameCustomersnon-unique index on Surname asc, GivenName asc
IX_product_nameProductsnon-unique index on Name asc
IX_product_descriptionProductsnon-unique index on Description asc
IX_product_sizeProductsnon-unique index on Size asc
IX_product_colorProductsnon-unique index on Color asc
2951pos12951pos1non-unique index on term asc, row asc, col asc, handle asc, position asc
2951stat12951stat1non-unique index on type asc, term asc
2951pos22951pos2non-unique index on term asc, row asc, col asc, handle asc, position asc
2951stat22951stat2non-unique index on type asc, term asc
ml_user UNIQUE (name)ml_usernon-unique index on name asc
ml_database UNIQUE (remote_id)ml_databasenon-unique index on remote_id asc
ml_table UNIQUE (name)ml_tablenon-unique index on name asc
ml_script_version UNIQUE (name)ml_script_versionnon-unique index on name asc
ml_column UNIQUE (version_id,table_id,name)ml_columnnon-unique index on version_id asc, table_id asc, name asc
ml_server UNIQUE (name)ml_servernon-unique index on name asc
ml_passthrough_script UNIQUE (script_name)ml_passthrough_scriptnon-unique index on script_name asc
ml_passthrough_status UNIQUE (remote_id,run_order,remote_run_time)ml_passthrough_statusnon-unique index on remote_id asc, run_order asc, remote_run_time asc
ml_qa_delivery_climl_qa_deliverynon-unique index on client asc
ml_qa_delivery_ordml_qa_deliverynon-unique index on clientaddress asc, status asc, priority desc, seqno asc
ml_qa_delivery_dldml_qa_deliverynon-unique index on client asc, syncstatus asc, status asc
ml_qa_deliver_origml_qa_deliverynon-unique index on originator asc
ml_qa_mstage_userml_qa_repository_stagingnon-unique index on mluser asc
ml_qa_sstage_userml_qa_status_stagingnon-unique index on mluser asc



Documentation generated by SqlSpec