Home » SQL & PL/SQL » SQL & PL/SQL » Index Creation on Table
Index Creation on Table [message #205223] Thu, 23 November 2006 23:51 Go to next message
Messages: 41
Registered: August 2006
I have a table which consists millions of rows in my production DB.While my user queries that table for information that takes more than 40minutes to fetch records from that table.
I decided to create a Bitmap Join index on this table,but,creating a Bitmap Join index will slowdown the update and insert operations very badly.So i dropped that idea.Now iam in confusion.Please help me with your suggessions on suitable index creation in the table.
Since this is very urgent please send your ideas As soon as possible.


Re: Index Creation on Table [message #205244 is a reply to message #205223] Fri, 24 November 2006 00:56 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Your question is the equivalent of "What sort of car should I buy?". It is too vague.

What sort of queries do you want to improve? Give a sample, plus the table structures, plus the volumes in each of the tables, plus the number of rows you expect to return, plus the acceptable response times you hope to achieve.

Ross Leishman
Previous Topic: Rownum inside 'Exists' subquery
Next Topic: Spool tables data in a text file using Stored Procedure
Goto Forum:

Current Time: Tue Oct 25 09:37:36 CDT 2016

Total time taken to generate the page: 0.20779 seconds