-
Perfomance in index creation
Hi!
A table already has a index on three columns (date_as_of,Brch_code,Porft_no) and partition on branch. To improve the performance took an export and created a new partitioned the table,imported the data and created some additional index on the date_as _of column for different quarters.
When the users query on the date_as_of columns its talking a long time. The record count in the table is 14680309
Cheers!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|