Trying to read a table in oracle (19c) large table having data more then 22 million rows.
The query response is Time Out error or Connection Lost . We also don’t have DB configuration to access. Is there any way to fetch row faster (Index and Partition are not an option)
Select * from table_name
where update_date >= DATE '2024-04-01'
or
Select * from table_name
where update_date >= to_date('01-APR-24 00.00.00','DD-MON-RR HH24.MI.SS')