Question Kumaresan R · Dec 2, 2017 Sql query optimization We have 1lakh records in table and while using sql select statement , it is taking more than 9mins to 12 mins to get the records. could you please how to optimize this performance issue if we have more records. how to optimize it. #Object Data Model #Performance #SQL #Caché 0 3 0 429