Last post Sep 30, 2010 04:14 AM by sirdneo
Sep 29, 2010 04:14 AM|aoshi_kh|LINK
will bad SQL query or tables not indexed properly cause any problem when we execute it? or it may just take more time to execute??
Sep 29, 2010 07:23 AM|Alpesh Patel|LINK
Improper use of Normalization and Index degrade the execution of query.
Sep 29, 2010 09:37 PM|aoshi_kh|LINK
yes i know that, but my point is when someone execute with bad SQL query or tables not indexed properly will it cause any problem?
Sep 30, 2010 04:14 AM|sirdneo|LINK
When you use nested queries, it will lock the table and if tables are not properly indexed then table will be locked for soo long that other operations will fail (like insert/delete)