1.Better data types,2.Better index algorithm,3.better query written techni

what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries

Question Posted / harjeet singh

Answer Posted / harjeet singh

1.Better data types,2.Better index algorithm,3.better query
written techniques which take the advantage of index

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many columns can you create for an index?

954

what is the default port for mysql server? : Mysql dba

1047

What is mysqlcheck do?

1025

What is the datatype of image in mysql?

919

What is a transaction? Describe mysql transaction properties.

1105

What is truncate command?

948

What is mysqli_select_db?

967

What is the datatype for password in mysql?

982

Why we use mysql workbench?

906

What is offset limit?

961

What is cursor in mysql?

897

What is mysql used for?

963

What is cast in mysql?

903

How to delete a database from mysql server.

1067

How to list or view all databases from the mysql server.

921