var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Slowly query
I have a table that contains 1157510 rows. When run a simple query i have to wait 1m and 8 sec to return 5 rows.
columnDate Between 'date1' and 'date1+15min'"
But then you have some special points.
1- I don't have an id field.
2- I don't have permision to create any index, or alter any thing in the table structure
Somebody have an idea to resolve this problem only with a query?
can you please send the indicies on this table.
In this tables don't have any indexes or any constraints.
well, then there is no other way than to do an FTS (Full table scan), which takes the time it takes, sorry.
Even when it returns 5 rows, it has to check in each and every page if each row is qualified for the select statement => Full table Scan.
BTW: having a heap is not always the best solution, consider to change the design of the table, if its to slow for your requirements.