I have a simple question:
Scenario:
Whose Perfomance is better ?
1)
DROP INDEX -->
TRUNCATE TABLE -->
AND THEN FILLUP DATA -->
AND THEN CREATE INDEX
2)
DROP TABLE -->
CREATE TABLE -->
FILLUP DATA-->
CREATE INDEX
I am using a table with millinos of recods. Which of these queries would suit my needs best?