Gauri Kanekar escribió: > I want the planner to ignore a specific index. > I am testing some query output. For that purpose i dont want the index. > I that possible to ignore a index by the planner. Sure: BEGIN DROP INDEX foo SELECT .... ROLLBACK -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.